Subject | V2.1.3 Faster than a speeding bullet |
---|---|
Author | Peter Bailey |
Post date | 2010-12-05T04:09:23Z |
Hello Firebird supporters
I recall, (I think), that V2.1 is expected to be about 40% faster than
V1.5, so I am very curious about some test results that I have generated.
The scenario is that I have a Delphi program that generates an XML file
from a Select Query.
Linking to fbembed.dll (gds32.dll) gives the following execution times
for the Select Query:
V1.5.5: 437 seconds
V2.1.3: 0.078 seconds
That makes V2.1.3 aprox. 5,600 times faster than V1.5.5!
Fantastic numbers for V2.1, but why is it so?
It may be relevant that the FB database is "small" — 6.5MB — and
therefore could easily be loaded into RAM, (4GB). The database structure
is ODS 10.1.
Thanks for any information.
Peter
I recall, (I think), that V2.1 is expected to be about 40% faster than
V1.5, so I am very curious about some test results that I have generated.
The scenario is that I have a Delphi program that generates an XML file
from a Select Query.
Linking to fbembed.dll (gds32.dll) gives the following execution times
for the Select Query:
V1.5.5: 437 seconds
V2.1.3: 0.078 seconds
That makes V2.1.3 aprox. 5,600 times faster than V1.5.5!
Fantastic numbers for V2.1, but why is it so?
It may be relevant that the FB database is "small" — 6.5MB — and
therefore could easily be loaded into RAM, (4GB). The database structure
is ODS 10.1.
Thanks for any information.
Peter