Subject RE: [IBO] TIB_Dataset.SysFetchNext too slow
Author Svein Erling Tysvær
Show us some code, Tobias, preferably also with the PLAN chosen and some information about table size/selectivity of indexes. Moreover, what about database statistics, if you have lots of updates and a large transaction gap, that could be at least part of the reason.


-----Original Message-----
From: [] On Behalf Of Tobias Giesen
Sent: 18. november 2010 19:37
Subject: [IBO] TIB_Dataset.SysFetchNext too slow


my dataset contains a lot of columns and I have a performance problem.

I need to be able to read at least 5000 records per second, but
TIB_Dataset.SysFetchNext gets only around 340 per second. I know
Firebird can do better.

The database server is an embedded Firebird 2.5.0.

What can be done to read data faster? Is there a more direct way to
get my data rather than using a TIB_Dataset descendant?

I can insert over 1500 records per second but read only 340. How
strange ...