Subject | speed comparison FB 1.0 vs. FB1.5 |
---|---|
Author | Bob Lazarchik |
Post date | 2003-10-14T01:08:01Z |
Hello:
I just finished a comparison between FB 1.0 and FB 1.5. I am using Delphi 6 C/S with IBExpress components a SLQ Query component, db and tn components only. This test involves inserting 200,000 records from a DBase file into interbase ( 138 fields into 1 table. these are flat files containing property information). I am running the inserts from a client across a LAN to a local server.
I have been planning to upgrade from 1.0 to 1.5 and decide to run this experiment before I did the upgrade. Here is the meat of the matter. Running exactly the same program, inserting the same records from the same client machine to the same host, across the same LAN I got the following.
FB 1.0.3 345 records/minute or 5.75 per second.
FB 1.5 rc 6 607 records/minute or 10.11 per second
In this test FB 1.5 is 43% faster.
Hope this information is worth while.
Thanks
Bob Lazarchik
[Non-text portions of this message have been removed]
I just finished a comparison between FB 1.0 and FB 1.5. I am using Delphi 6 C/S with IBExpress components a SLQ Query component, db and tn components only. This test involves inserting 200,000 records from a DBase file into interbase ( 138 fields into 1 table. these are flat files containing property information). I am running the inserts from a client across a LAN to a local server.
I have been planning to upgrade from 1.0 to 1.5 and decide to run this experiment before I did the upgrade. Here is the meat of the matter. Running exactly the same program, inserting the same records from the same client machine to the same host, across the same LAN I got the following.
FB 1.0.3 345 records/minute or 5.75 per second.
FB 1.5 rc 6 607 records/minute or 10.11 per second
In this test FB 1.5 is 43% faster.
Hope this information is worth while.
Thanks
Bob Lazarchik
[Non-text portions of this message have been removed]