15.000 inserts are not that big problem as you think.....

With a fast machine (in my Case, Dual XEON with IB_Affinity, 6-LVD-disks in
RAID5, 2GB of RAM) and forced writes off I can go up to 12.000 rows/sec
easily.
The trick is to disable all indizes prior to inserting and using a prepared
insert-statement with parameters.
With IBObjects and a DSQL-component, you will get these speeds. No need for
the API on this....

On my home-machine, Athlon900 with IDE-raid and 768MB of Ram, I go up to
6.000 insert per second. Note, that I have to generate the data for this in
realtime, so there is room for about another 20%, as the Interbase-service
is using roughly only 65-70% of the CPU.....

Ah, yes, this was done on a local machine.....for remote connections, the
network is the limit, not Interbase.

CU, Kaputnik
(Nick Josipovic)

nick@...
kap@...
-----------------------------------------------------------------------
superior Client/Server programming:
www.IBObjects.com
a nice Tool for Interbase:
www.InterbaseWorkbench.com

----- Original Message -----
From: "Ali Gokcen" <alig@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, January 29, 2001 8:26 PM
Subject: Re: [ib-support] Re: Writing data in tables!


> 15,000 insert /second ?
> what about is this project ? stauroscope data? realtime image capturing ?
> you can't find any standart database system to do this.
> if your inserts need db for a few seconds immediatly, you can write them
> quickly to an external table file and transfer them in idle time. or use a
> special RAMDISK drive.
> i think using API will not improve the performance, insert components are
> allready lowest level.
>