Yes, I just ran a test sample here inserting within one second 10,000
random rows consisting of 16 various numerical values, final commit
included. But excluded time to setup the DB connection, time to start
transaction, time to prepare statement. Just the loop of 10,000 execute of
that prepared statement, on a local connection on Windows 2000 (PII 450
Mhz, 128 Mb ram), connection settings default, except for forced writes
off, of course.

That means nothing and all, of course. The question remains : is database
inserts the right way to capture huge amount of probably live data ? I
think no. But under reasonably modest environmental conditions IB can
indeed eat up those 15,000 rows a second easily.

Olivier Mascia.

--On lundi 29 janvier 2001 20:36 +0100 Kaputnik <delphi@...> wrote:

> 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.
>>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>