Did you create an index for your Interbase table? Your benchmarks do seem
out of line. Interbase should be faster than 15 seconds even with a very bad
setup. With proper optimization, and transaction handling, I would bet that
the Interbase system would easily beat the 2 second Paradox test in your
example. There were some speed benchmarkings done a while back. I think
Interbase could do something like 15,000 insertions per second, but Im just
going by memory and may be way off.

Paradox is a "flat file", not a database server. On small tables and small
user counts, it will be faster than Interbase. On medium and larger
databases Interbase will be faster.

Your database corruption is a very hefty price to pay for the small speed
advantage that Paradox offers. I would not even consider Paradox for any app
anymore. The corruption occurs far too often. Also dont forget about
transactions, triggers, stored procedures, domains, etc. There are way too
many advantages of Interbase to discuss here.

Paul

----- 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.
>
>
>
>
>
>
>