Geno,

I am going through a similar situation and have found IB to be much faster
then Paradox. For bulk inserts you really should be using the TIB_DSQL
component with an INSERT INTO statement. It has very little overhead and is
extremely fast.

Chris Landowski
Dynamic Software Solutions

----- Original Message -----
From: "Geno " <strtline@...>
To: <IBObjects@egroups.com>
Sent: Sunday, January 07, 2001 9:56 AM
Subject: [IBO] Interbase,Advantage,Paradox


> Hello:
>
> I have been reading the posts about the speed advantages of Interbase
> over the BDE. It seems to be agreed that Interbase is much faster.
> This leads me to believe I must be doing something wrong. I am a
> novice to both Interbase and IBO. I have several applications that
> have been running for years which are written in D5 with
> BDE/Paradox. They are all applicaations that run on local networks
> with less that 10 users. They all run fine except for the nasty
> habit of Paradox to get corrupted indexes. Because of this, I
> thought switching to another database might be a good idea. My first
> switch was to Advantage. It worked fine and was relatively fast but
> the Advantage local server does not support transactions. I was
> going to purchase the Advantage remote server when I heared about
> Interbase. Since it was free, it seemed foolish to spend money on
> Advantage.
> I have been working on converting the application and one of the
> first things I noticed was how much slower everthing ran. I created
> a few test progams that simply loop and add 1000 records to each
> different type of database. The table format is simple:
> TheKey : Integer;
> TheField : Character[20];
>
> The loop is for the BDE\Paradox version is:
>
> For Loop := 1 To 1000 Do
> Begin
> Table1.Insert;
> Table1.FieldByName('TheKey').AsInteger := Loop;
> Table1.FieldByname('TheField').AsString := 'ABC';
> Table1.Post;
> End;
>
> The loop for the Advantage and Interbase versions use querys instead
> of tables but are otherwise similar.
>
> In the BDE/Paradox version, the records are added in roughly 2
> seconds. In the Advantage local server version, around 5 seconds.
> In the Interbase version, around 15 seconds. In the Interbase
> vsrsion this seems true if I use a DataSource/IBOQuery or IBOTable or
> a IB_DataSource/IB_Query.
>
> I realize it is probable that I should be optimizing the application
> for use with Interbase. However, my plan was to first convert to
> Interbase using DataSource/IBOQuerys then eventually to
> TIB_DataSource/IB_Querys.
>
> Can someone tell be what I am doing wrong?
>
> Thanks.
>
>
>
>
>
>