ODBC vs. InterBase - Is it worth upgrading?

Hello.

My question is:

I have an application which works from MDB through ODBC, but the forms open quite slow because of creating the form and refreshing the queries. I wonder if it was worth to export my MDB to InterBase. Would it be much faster or not?

Thank You
Joseph Bernath

I've never used InterBase because every client needs BDE to access the tables.

Perhaps optimizing your code would increase the loading time ...

For instance ...

Use ADO objects ...
Use SQL Queries ...
Do not load the whole table at once, only the visible part ...

Regards

/Filip

If you lose BDE and go with Interbase Express (comes with delphi 5).. I've noticed quite a bit of improvement over access, epecially over tcp/ip (internet) with multiple clients.

You will have to learn a bit about indices,etc...