At 11:24 AM 10/4/2004, Alexandre Kozlov wrote:

>3) Simple "SELECT COUNT(*) FROM LargeTable" will probably may take hours (of
>course, after cache stabilized it will take just about 1 minute)

OK, and if you really really care about how long it takes to count
all the records in a large table, you probably should either use
a different database, or find some way to maintain the count without
having to touch every record. In Firebird, SELECT COUNT (*) is not
a simple operation, it's a simplistic performance trap, which real
programs solving real problems never use. Tuning the system, or
complicating the system tuning to improve SELECT COUNT(*) on a large
table with an empty cache is a waste of time.

Regards,


Ann