> We have converted an app from paradox to interbase.
> So the tables are the same, the indexes are the same, even the data
> is the same dataset - just datapumped from paradox to interbase.

> SNIP

> Any ideas ?

How many records? 50 seconds could be a bit excessive, but
you have asked for a COUNT of all the records.

A desktop database will always be faster on small simple
actions.

A client\server relational database has a lot more overheads
to getting the answer.

The difference comes when you want 10 people all updating
information on a complex set of information.

That said, COUNT can be a problem as it needs to know which
records to include, and some may be in the process of being
updated so that they may or may not be included in the count
when it is run again. It is normal in a client\server
environment to manage record counts that are regularly used
by actually keeping a count record or table.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services