> > One thing I did notice that in a 250k insert transaction the insert
time
> > grows with #recs inserted. Time to insert first 50k recs is about
27
> > sec and last 50 k recs is 77 sec. I also confimed that size of
table is
> > not playing a role here.
> >
> > Marc, can you do select timeofday() every 50k recs from linux? Also
a
> > gprof trace from linux would be helpful.
> >
>
> Here's the timeofday ... i'll do the gprof as soon as I can.
> Every 50000 rows...
>
Were those all in a single transaction?
Merlin