insert into victim
select gen_id( victimgen,1), cast(gen_id(victimgen,0) as varchar(10)),
'29.1.2001', '10:20'
from victim where gen_id(victimgen,0) <= 15000;

i tried this server side insert on my fossil PC
( AMD/K6-2 350MHZ, 64 MB RAM, 3.2 GB UDMA16 QUANTUM/fragmanted, w2k )
it took 2000 inserts/second ( dialect 3, firebird 9.4.1, there is one
UNIQE index ) its good enough.
I think IB can do 15000 inserts/sec. on a good machine.
but who can give quarantie for next 15000, or last 15000 recs ?
or what will we do when another user / application /system requests sysIO
...

----- Original Message -----
From: Kaputnik
To: ib-support@yahoogroups.com
Sent: Monday, January 29, 2001 9:36 PM
Subject: Re: [ib-support] Re: Writing data in tables!


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



Yahoo! Groups Sponsor

www. .com




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com