Subject Re: [firebird-support] Large record count - will it work?
Author Indysoft Bt.
Hello!

In one of my previous post I mentioned that I made a load test with FB.
I have a table with 4 INTEGER, DATE, AND VARCHAR fields. There are
50.000.000 records in it. With well planned queries (and having the
appropriate indexes as well) the response is dramatically fast. I used
grouping, ordering, between, etc on the test table, but there where no
problem.

The insert speed from a Delphi client, based on IBX, with a prepared
statement is about 5-6000 records/sec. (AMD Athlon 2800+, 1 GByte RAM,
IDE HDD,Win2K Workstation) This is very well performance, I think.

I came from MSSQL (Yukon), because it has performed very poorly in this
situation (on a much more powerful machine, of course), compared to FB.
Ok, maybe I am not an MSSQL guru, but all the solutions provided by MS
supporters, was unusable. FB solved our problem.

Regards:Alex :-)