Subject | TIB_Dataset.SysFetchNext too slow |
---|---|
Author | Tobias Giesen |
Post date | 2010-11-18T18:37:04Z |
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
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