Subject | RE: [firebird-support] Windows vs linux server performance |
---|---|
Author | David Suárez |
Post date | 2006-01-25T09:36:40Z |
> What do you get when outputing to /dev/null?Same result on both
> What if you access the database with "localhost:/data/testblob/01.fdb"?
time /opt/firebird/bin/isql -u SYSDBA -p masterkey /tmp/rep1024.fdb -i
inputfile > /dev/null
real 1m36.744s
user 0m0.087s
sys 0m0.076s
time /opt/firebird/bin/isql -u SYSDBA -p masterkey
localhost:/tmp/rep1024.fdb -i inputfile > /dev/null
real 1m36.735s
user 0m0.085s
sys 0m0.080s
> Have you tried using Linux isql to access Windows FirebirdThis shows an unexpected result:
> and vice-versa?
Linux isql -> windows server: 42 seconds (as expected)
Windows isql -> linux server: 36 seconds (not as expected)
>A test program using firebird.net provider. Indeed we thought it was the
> Which tool have you used to insert data?
provider, with a different implementation for windows and linux that had the
problems, but discarded after testing with isql.
As a curious result, firebird embedded server in linux shows same speed as
windows embedded. Firebird windows server is twice as slow (which is what
one'd expect, as it uses network protocol instead of direct library calls).
However, firebird server is between 15 and 20 times slower than linux or
windows embedded.