Subject Re: [IBO] Is IBX better than IBO when used threaded ?
Author Pelle F. S. Liljendal
Thanks for your answer Carlos I will try to test it using TIB_DSQL
in stead of TIBOQuery, however disabling the indexes is not
practical in a multiuser environment where other users might be
using those same indexes.

I would normally not do an index like I did in this test-program
(which has indexes on 1 and 2 VARCHAR(40) fields). Normally I only
have 1 Primary Key(INTEGER), 1 Unique Index (1 or several INTEGER
fields) and thoses indexes that are automacially created when you
have FOREIGN KEY relations. The only reason I did these INDEXes in
my test application was to "emulate a workload" on the DB-server.

My biggest concern is "why IBX is faster that IBO" (still hoping
this is not the case, and I did some error in my IBO version of the


> You are using TIBOQuery component which is a little slow than
> TIB_Query, but in your example use TIB_DSQL instead with one
> for each 1000 inserts and try do disable indexes while inserting
> massive records enabling it at the end.
> I hope this changes help you,
> Carlos Macao