Subject | Re: [firebird-support] Large record count - will it work? |
---|---|
Author | Indysoft Bt. |
Post date | 2009-02-17T09:32:21Z |
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 :-)
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 :-)