FetchSize Query
Posted: Mon 02 Oct 2006 12:49
I'm experiencing something odd when using PgSqlCommand with FetchSize.
This will give me a total of 400,000 records. However, I know I've got just over 407,000 records, so if I then do
(so in effect forcing the loop again) I then get the correct amount out. I've tried this with varying values of FetchSize and it appears to be the last 'chunk' isn't retrieved. So for above, if I change FetchSize to be 5,000, then 405,000 is retrieved (in the main Read()), and 2,000 odd in the additional Read().
I'm not sure if this is a potential bug, me not using the feature correctly, or some weird configuration on my system, but thought I'd throw it your way for comment.
Cheers,
Jon.
Code: Select all
PgSqlCommand pgCommand = new PgSqlCommand("select column_name from table_name", myPgConnection);
pgCommand.FetchAll = false;
pgCommand.FetchSize = 10000;
pgSqlDataReader pgReader = pgCommand.ExecuteReader();
long Counter = 0;
while(pgReader.Read())
++Counter;
Console.WriteLine("{0} records read", Counter);
Code: Select all
while(pgReader.Read())
++Counter;
Console.WriteLine("{0} records read", Counter);
I'm not sure if this is a potential bug, me not using the feature correctly, or some weird configuration on my system, but thought I'd throw it your way for comment.
Cheers,
Jon.