Hi all,
I am maintaining a group of applications which share Access databases. In the newer version of the software products we have upgraded from DAO to ADO and also implemented routines to upgrade the databases from Access 97 to Access 2000.
However, bitmaps stored in the Access 97 databases when retrieved into a recordset using the older versions of our software (that used DAO) were accessed at a good speed. However, in the newer versions (which use ADO and the databases are converted to an Access 2000 format), when the same recordsets with the bitmaps are retrieved, it is extremely slow to open the recordset. When removing the bitmap data from the databases, it works fine so it seems like its something to do with retrieving large BLOB data from the database.
The only way round this problem we can see (which I have already started implementing) at the moment, is to programmaticall y convert all bitmaps stored in the database into JPEGs during the upgrade routines to the new version of the software (which now uses ADO and Access 2000).
Is this just purely because ADO is slower than DAO at retrieving large BLOBs from a database or is it something i have missed during the conversion process on the databases? If anyone has any ideas, it would be greatly appreciated!!
Thanks in advance
I am maintaining a group of applications which share Access databases. In the newer version of the software products we have upgraded from DAO to ADO and also implemented routines to upgrade the databases from Access 97 to Access 2000.
However, bitmaps stored in the Access 97 databases when retrieved into a recordset using the older versions of our software (that used DAO) were accessed at a good speed. However, in the newer versions (which use ADO and the databases are converted to an Access 2000 format), when the same recordsets with the bitmaps are retrieved, it is extremely slow to open the recordset. When removing the bitmap data from the databases, it works fine so it seems like its something to do with retrieving large BLOB data from the database.
The only way round this problem we can see (which I have already started implementing) at the moment, is to programmaticall y convert all bitmaps stored in the database into JPEGs during the upgrade routines to the new version of the software (which now uses ADO and Access 2000).
Is this just purely because ADO is slower than DAO at retrieving large BLOBs from a database or is it something i have missed during the conversion process on the databases? If anyone has any ideas, it would be greatly appreciated!!
Thanks in advance