Image fields & ODBC 
Author Message
 Image fields & ODBC

We are using image fields in some tables (SS 6.5) and are experiencing
severe slowdowns when the columns are populated the FIRST time.  The MFC
database classes (via ODBC) generate the statements:

        SELECT TEXTPTR(blob) from table where blob like 0x2345..........

followed by a:

        WRITETEXT BULK table.blob 0xdata..... WITH LOG

We believe the SELECT TEXTPTR is the slow operation (so slow we now issue
our own UPDATE statements).

Anyone experienced this?

Fri, 05 Nov 1999 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. images in image fields and field bloat

2. ADO & SQL Server7 image/binary field

3. Blob Field & images greater then 32 Kb

4. Data field & control about image

5. Image field in Access & VB5

6. Image & Text fields

7. ODBC - inserting 1-Meg into image field

8. image Field (OLE) and Access ODBC driver

9. Image & MS SQL 6.5 + ODBC

10. Problem storing image field with ODBC

11. Image Field Manipulation via ODBC..

Powered by phpBB® Forum Software