On Wed, May 04, 2005 at 09:04:30AM -0400, Steve Sapovits wrote: > Scott T. Hildreth wrote: > > >As Tim said, look at the RowCacheSize, I have seen big speed gains > >by increasing this attribute. > > We do use that and I have also seen decent (maybe not big) gains. > The big problem we have with it is maintaining a good setting as > our data grows, since we usually set it to a number of rows.
For DBD::Oracle, setting it to a negative value lets you define an amount of memory to use rather than the amount of rows. Tim.