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