Re: optimum pageSize

2007-01-25 Thread Nurullah Akkaya
sorry for the typo it should have been 15 bytes not KB i wont be reading the same records over and over again once i read them i will calculate and put the result in cache so i wont be reading the same records until next reboot what i want to do is make that initial read as fast as i can.

Re: optimum pageSize

2007-01-24 Thread Stanley Bradbury
Nurullah Akkaya wrote: my application uses a large table ( more than 200 million ) 15k rows that uses integer index to do simple selects no sorting but i do have to read 1 to 2 million records at a time. i read in the tuning manual that if we have large tables we should use a large pageSize it