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.

Set

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

Hello,

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

Cheers,
Tobias