| Subject | Slow Fetch 100,000 records table |
|---|---|
| Author | radevojvodic |
| Post date | 2007-06-19T06:35:59Z |
Hi all,
I have a table with 100000 rows, primary key is VARCHAR(15) and
Description COLUMN is varchar(60). Character Set Win1250, Firebird 2.0
IBO 4.4 build 16.
In design time fetching all the records lasts 2 s., but in the runtime
it lasts 15 secs. What could be the problem.
(Simple query Select COl1, COl2 From Table).
In IB expert it is under 2 secs.
Rade
I have a table with 100000 rows, primary key is VARCHAR(15) and
Description COLUMN is varchar(60). Character Set Win1250, Firebird 2.0
IBO 4.4 build 16.
In design time fetching all the records lasts 2 s., but in the runtime
it lasts 15 secs. What could be the problem.
(Simple query Select COl1, COl2 From Table).
In IB expert it is under 2 secs.
Rade