Hi,

I have a VB6 application that uses MS Access as BE database through ADO.
It is a single-user application.

It;s a highly intensive data processing app, and I need its processing
speed to increase. I don't need multi-users shared access.

I just found the firebird db and saw it has an embeded version. Is it
possible with this version to make my app use database and do all
processing in memory (without flushing to disk)? Well, I will want
floshing to disk only after the whole processing, since there asre no
concurent users who need to get access to database.

I guess this could increase the speed of the app.

Also, how fast is firebird , compared with MS Access?

I thought of firebird because I saw it has OleDB provider, so I can use
it with ADO and this will involve only minor changes in my app (maybe
slightly adjustments to queries, since the whole processing, incliding
running queries, retriaving recordsets , etc will remain unchanged

Also, if you could give me some suggestions how to maximally optimnize
speed, by giving up at multi-user, and wioth help of embeded engine, I'l
highly appreciate.

Thank you

Bogdan Zamfir