Subject TIB_Dataset.SysFetchNext too slow
Author Tobias Giesen

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 ...