Tiberiu,

Sorry to take so long to respond to your initial message. I got bogged
down in some other issues.

The tests I ran were using page size 4096, -buffers 72, -writes aysnc
and -housekeeping 20000

Changing to settings to -buffers 8192 -writes async -housekeeping 0
results in 657534 records inserted in 297 seconds (2213.91919191919
records / sec).

I also get roughly the same performance regardless of whether or not i
have just created the database, or have dropped the table, recreated,
and re-filled it.

It seems like there must be some sort of bottleneck outside of the
low-level database engine.

--erik


Tiberiu Atudorei wrote:

>>Any other ideas?
>
>
> First of all, you didn't answer about forced writes =0.
> This parameter is specific to the database
> (like page size, sql dialect, sweep interval, buffer pages).
>
> So, other ideas (from these parameters):
>
> 1. forced writes=0;
> 2. sweep interval=0;
> 3. buffer pages...let's say 8192
> 4. force some 'expansion' of the database file by inserting
> a large number of rows and then deleting them ...that would
> insure enough free space and avoid any requests to the OS
> to allocate more space to database...
>
> Change parameters 1..3 with IBAccess/IBExpert/IBConsole
> and please post the results of your test....
>
> Tiberiu
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--
Erik S. LaBianca <erik@...>
Developer / System Administrator, Interlink, Inc.
Voice: (269) 473-3103 Fax: (269) 473-1190
http://www.totalcirculation.com