Re: [GENERAL] slow inserts and updates on large tables

> > if 100 inserts/second and 40 updates/second is all i can realistically
> > expect, then i will have to investigate alternate databases (likely
> > commercial ones like Progress on SCO, yech!).
> >
> > if anyone has any pointers as to why this is so slow, lemme know.
>
> What's -B ?

it is whatever the default is.

> Do you use BEGIN/END to run _many_ updates/inserts in
> _single_ transaction ?

i tried that and it didn't seem to make much difference.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]