Subject Slow Fetch 100,000 records table
Author radevojvodic
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.