Subject | Re: [IBO] Newbie Question -- Inserts slow? |
---|---|
Author | Daniel Rail |
Post date | 2002-06-07T21:06:16Z |
At 07/06/2002 04:20 PM, you wrote:
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)
>I'm checking out IBObjects (Coming from an IBX background).Have you tried using TIB_DSQL or TIB_Script? With TIB_Script, you could
>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?
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)