ArcSDEQuery's resultCount is unusable on heavy layers
-----------------------------------------------------
Key: GEOT-2355
URL: http://jira.codehaus.org/browse/GEOT-2355
Project: GeoTools
Issue Type: Bug
Affects Versions: 2.5.2
Reporter: Fredrik Holmqvist
Attachments: ArcSDEQuery_result_count.patch
The current implementation of resultCount takes 5 minutes to execute on our
heaviest layer. (What's worse is the usage of session is not reentrant, making
all sessions to the ArcSDE database wait for those 5 minutes. I suspect flawed
locking, maybe a bad call to synchronized somewhere in these critical sections,
making the whole session handling working in serial instead of parallell.)
Here is a patch to fix resultCount which reduces the time to less than 1 second
instead of 5 mins.
Afaict there is no ill effects, but it needs proper testing.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
