Subject Re: [IBO] Newbie Question -- Inserts slow?
Author Daniel Rail
At 07/06/2002 04:20 PM, you wrote:
>I'm checking out IBObjects (Coming from an IBX background).
>A simple test app I have to test relative speed is failing miserably
>using IBObjects (At least, as compared to IBX). My guess is that I
>just have something set up wrong. :)
>
>Anyways, it runs an external script file, which just contains a mass
>of inserts, of the form:
>
>insert into temp values ('86147','136.1','136.1');
>insert into temp values ('86147','279.4','279.4');
>insert into temp values ('86147','283.0','283.0');
>insert into temp values ('86147','287.3','287.3');
>insert into temp values ('86147','287.4','287.4');
>[...snip...]
>I'm running on FB 1.0, WindowsXP Pro, forced writes enabled.
>My guess is I have something wrong/am using the wrong
>components/something, as IBO is supposed to be at least around the
>same performance as IBX, I thought, if not faster.
>
>Can anyone shed light on what I might be doing wrong?

Have you tried using TIB_DSQL or TIB_Script? With TIB_Script, you could
load all of the file into it and execute it. Also, make sure your database
file extension is not ".gdb", WinXP monitors these files for the system
restore.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)