Subject | Re: [IBO] Is IBX better than IBO when used threaded ? |
---|---|
Author | Carlos Macao |
Post date | 2003-11-01T11:44:52Z |
Hi Nando,
wanted to target so I post a number of possible ways to improve
insert statement. Of course disabling indexes and committing for each
1000 records, it's only useful for certain specific implementations,
like massive inserts (and this is really useful in such conditions)
but this wasn´t the main change I pointed to him, which was:
replacing TIBOQuery for TIB_DSQL.
maintaining the environment conditions is always a must.
plus
you reach the same conclusions. Why? Only Jason can tell us.
Best regards,
Carlos Macao
> I couldn't really understand the meaning of Carlos' benchmarks,When Pelle first post his message I didn't know what scenarios he
> since it looks like he did other changes (like deactivating indexes
> and committing every x inserts) other than switching to IBO.
wanted to target so I post a number of possible ways to improve
insert statement. Of course disabling indexes and committing for each
1000 records, it's only useful for certain specific implementations,
like massive inserts (and this is really useful in such conditions)
but this wasn´t the main change I pointed to him, which was:
replacing TIBOQuery for TIB_DSQL.
> In addition, a meaningful benchmarks should act on the sameOf course I did, when I say a repeated the tests more then once,
> database each time and Carlos didn't say whether this one has been
> conducted this way or not.
maintaining the environment conditions is always a must.
> Anyway, I am particularly concerned by the poor performance ofThat´s a fact and comparing with other TDataset layers like FIB
> IBODataSet.
plus
you reach the same conclusions. Why? Only Jason can tell us.
Best regards,
Carlos Macao