Subject | Fetch performance question. |
---|---|
Author | Mitch Peek |
Post date | 2006-08-07T00:44:28Z |
FB 1.5.2 SuperServer
Hope I am on track with what I am observing here.
I have a stored procedure and the result is used to produce a report.
The procedure executes typically in the 3 - 4 second range. However,
the fetch takes considerably longer. For instance, the procedure
currently produces 1553 rows of data.
I have eleimanted the network (for testing) the DB is local, although i
am connecting using 127.0.0.1:DBAlias not sure this important, but...
The fetchall actually can take several minutes to complete. The best
performance I have seen is about 2.5 minutes to fetch these 1500 rows.
the row itself isn't wide, no blobs, 7 numerics, 2 integers, and 4
varchar(50).
Any Ideas?
Thanks,
Mitch
Hope I am on track with what I am observing here.
I have a stored procedure and the result is used to produce a report.
The procedure executes typically in the 3 - 4 second range. However,
the fetch takes considerably longer. For instance, the procedure
currently produces 1553 rows of data.
I have eleimanted the network (for testing) the DB is local, although i
am connecting using 127.0.0.1:DBAlias not sure this important, but...
The fetchall actually can take several minutes to complete. The best
performance I have seen is about 2.5 minutes to fetch these 1500 rows.
the row itself isn't wide, no blobs, 7 numerics, 2 integers, and 4
varchar(50).
Any Ideas?
Thanks,
Mitch