optimum pageSize

[Nurullah Akkaya]

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 also  
says if queries use index it could degrade performance what should be  
the right pageSize for a application of this type?


Nurullah Akkaya
[EMAIL PROTECTED]

Blooby.com
Tel: +1 (256) 270 4091