--- In firebird-support@yahoogroups.com, "Bob Lazarchik"
<bob2307@t...> wrote:

> Hello:
>
> I just finished a comparison between FB 1.0 and FB 1.5. I am using

Delphi 6 C/S with IBExpress components a SLQ Query component, db and
tn components only. This test involves inserting 200,000 records
from a DBase file into interbase ( 138 fields into 1 table. these
are flat files containing property information). I am running the
inserts from a client across a LAN to a local server.

>
> I have been planning to upgrade from 1.0 to 1.5 and decide to run

this experiment before I did the upgrade. Here is the meat of the
matter. Running exactly the same program, inserting the same records
from the same client machine to the same host, across the same LAN I
got the following.

>
> FB 1.0.3 345 records/minute or 5.75 per second.
> FB 1.5 rc 6 607 records/minute or 10.11 per second
>
> In this test FB 1.5 is 43% faster.
>
> Hope this information is worth while.
>
> Thanks
>
> Bob Lazarchik
>
>
>
> [Non-text portions of this message have been removed]

what about update ? will update take longer time than insert ?

rgds