BDE Slow? Is there a way to speed up?

[cjtaylor]

I am using the BDE to store bitmap images along with user data. The total record size is around 90k. I wonder why it takes 15-20 seconds just to open the table(only 15 records right now) then another 10-15 seconds to post new data to the table. Is there a reason why this should take so long? Or should I use another database system?

Thanks for any tips

 

[hnd]

It depends on your databaseprogram which is behind BDE.

Basically such big records are slowing down each transfer. I think it would be better to store the pictures on a different path and put only the references (File Names) into the Database.

If you are working in a network then forget all non sql-based Databases.


hnd
hasso55@yahoo.com

 

[2ffat]

You also have two more options: tweak BDE or use an alternative. The choice may depend on your data base, network, cost, etc.

From what I've read, BDE is not the best choice for multi-user, networked systems. On

http://community.borland.com

there was an article named "Maximizing Performance of Delphi/C++/Interbase Applications" (article #27569 I think). In this article, they mention that you can get a performance increase of 40% by just using native drivers for your data base, e.g., IBX for Interbase or ODBC for most SQL DBs.

If using native drivers is not an option you may have to configure BDE. There is an article at

http://www.bytamin-c.com

that discusses how to optimize BDE. It is located in their "How-To" section and is titled "How to configure the Borland Database Engine."

James P. Cottingham

I am the Unknown lead by the Unknowing.
I have done so much with so little
for so long that I am now qualified
to do anything with nothing.