Subject | Re: [IBO] Is IBX better than IBO when used threaded ? |
---|---|
Author | Carlos Macao |
Post date | 2003-10-31T20:28:55Z |
Hi Pelle,
After my previous answer I play a little with your sources and came
to a more precise comparison using your project demo:
Firebird version: 1.5 SS RC6
IBO version: 4.2 If test
IBX version: 6.04
Hardware: Pentium 4M 2.4 Ghz
OS: Win XP RC1
Using your demo untouched with forced writes=off, with 1 thread (I
couldn't put to work your demo with more then one thread), with
automatic garbage disabled, for 20000 record inserts I got :
76 inserts per second.
Using your demo for ibx, I've got:
691 inserts per second.
Using the same racing conditions but with IBO components replaced by
dsql ones, with indexes disabled and commit for each 1000 inserts,
I've got:
2314 inserts per second.
I repeated this tests more then once.
Carlos Macao
After my previous answer I play a little with your sources and came
to a more precise comparison using your project demo:
Firebird version: 1.5 SS RC6
IBO version: 4.2 If test
IBX version: 6.04
Hardware: Pentium 4M 2.4 Ghz
OS: Win XP RC1
Using your demo untouched with forced writes=off, with 1 thread (I
couldn't put to work your demo with more then one thread), with
automatic garbage disabled, for 20000 record inserts I got :
76 inserts per second.
Using your demo for ibx, I've got:
691 inserts per second.
Using the same racing conditions but with IBO components replaced by
dsql ones, with indexes disabled and commit for each 1000 inserts,
I've got:
2314 inserts per second.
I repeated this tests more then once.
Carlos Macao