how does fetchall work?
Posted: Tue 29 Aug 2006 21:31
1. I have a table with 10000 records (Using TMSTable component).
2. I am opening it with:
Cursortype = ctDefaultResultSet;
FetchAll = false;
FetchRows = 25;
ParamCheck:=true;
Options.QuoteNames:=true;
Options.FullRefresh:=true;
Options.LongStrings:=False;
Options.QuoteNames:=true;
Options.TrimFixedChar:=true;
Options.TrimVarChar:=true;
Options.RemoveOnRefresh:=true;
Options.AutoPrepare:=False;
3. According to the manual, opening this table should be prompt, due the small amount of initial fetching records, but it is not. It takes about 1 minute.
4. Even if I reduce or augment the fetchrows property, it does not seem to have any influence over the opening time.
5. What could possibly be the reason? How can I assure the initial retrieved set size is that I set up in Fetchrows?
6. The DBMonitor sentence, each time I open it, is "Select * from table". How does MSSQL "know" about the fetchrows number, since I am sending only that sentence thru network?
Thanks for any help.
2. I am opening it with:
Cursortype = ctDefaultResultSet;
FetchAll = false;
FetchRows = 25;
ParamCheck:=true;
Options.QuoteNames:=true;
Options.FullRefresh:=true;
Options.LongStrings:=False;
Options.QuoteNames:=true;
Options.TrimFixedChar:=true;
Options.TrimVarChar:=true;
Options.RemoveOnRefresh:=true;
Options.AutoPrepare:=False;
3. According to the manual, opening this table should be prompt, due the small amount of initial fetching records, but it is not. It takes about 1 minute.
4. Even if I reduce or augment the fetchrows property, it does not seem to have any influence over the opening time.
5. What could possibly be the reason? How can I assure the initial retrieved set size is that I set up in Fetchrows?
6. The DBMonitor sentence, each time I open it, is "Select * from table". How does MSSQL "know" about the fetchrows number, since I am sending only that sentence thru network?
Thanks for any help.