Hi
I've linked Access, using Unicode ODBC driver, to a MySQL backend that collates images using a third party app. Accessing the underlying table is very slow, as is a simple 'passthrough' query on the same table.
By removing the 'Image' (yes, I know it's a reserved word but I don't have Admin rights to edit the SQL table) from the Query it speeds up considerably - 3 records querying the Image field takes approx. 20 seconds, over 1k records based on a single text field is instantaneous so it appears the server connection is satisfactory.
The 'Image' field in the underlying table is stored as an 'OLE Object'. Can the speed of the database be improved through other means? I've read a little about a commercial component called DBPix but would prefer not to resort to that cost.
Would appreciate your thoughts
I've linked Access, using Unicode ODBC driver, to a MySQL backend that collates images using a third party app. Accessing the underlying table is very slow, as is a simple 'passthrough' query on the same table.
By removing the 'Image' (yes, I know it's a reserved word but I don't have Admin rights to edit the SQL table) from the Query it speeds up considerably - 3 records querying the Image field takes approx. 20 seconds, over 1k records based on a single text field is instantaneous so it appears the server connection is satisfactory.
The 'Image' field in the underlying table is stored as an 'OLE Object'. Can the speed of the database be improved through other means? I've read a little about a commercial component called DBPix but would prefer not to resort to that cost.
Would appreciate your thoughts