buppcpp wrote:

>
> With all due respect Ann, how will adding more user to the database
> help with this problem, it seems like it will only make it worst.

So far, you've shown us a problem with finding the fifty unique store
numbers from a table of 2.1 million records, using either distinct or
group by. We all agree that Firebird's performance there is not good.

If that's all you really want to do, several people have offered
possible solutions that would improve performance on both systems - even
15 seconds is a long time to wait for a list of stores.

If, on the other hand, you want to get the store number and the average
number of SKUs per store, you'd see less of a difference between the two
systems. If, for example, you need to produce at two-pass report of
sales per store while other users continue to record new sales, new
stores, and make accounting corrections, you'll probably see yet a
different performance profile.


Regards,


Ann