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