Subject | RE: [IBO] TIB_Dataset.SysFetchNext too slow |
---|---|
Author | Svein Erling Tysvær |
Post date | 2010-11-19T10:06:08Z |
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
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