Opened 12 years ago
Last modified 12 years ago
#819 new defect
Slow performance in combination with Mapguide and multiuser access
| Reported by: | sgamperl | Owned by: | haris |
|---|---|---|---|
| Priority: | major | Milestone: | 3.6.0 |
| Component: | KingOracle Provider | Version: | 3.6.0 |
| Severity: | 1 | Keywords: | |
| Cc: | External ID: |
Description
We are using the Mapguide Open Source Server 2.2 or the Autodesk Infrastructure Server with FDO 3.6.0. There we access an Oracle 11 enterprise database through the SL King Oracle FDO Provider. If more than 2 or 3 user access a map through the MapGuide server the response times are very slow. They are nearly linear in comparison to the number of users accessing the map. Is the Oracle connection shared between the several users? It seems that the MapGuide FDO connection pool isn't used with the SL King Oracle provider. On the other hand, the commercial Autodesk FDO Oracle provider is much faster and seems to handle the requests in parallel. However the commercial provider have other problems, so we would like to use the SL King Oracle provider. Maybe the issue is already fixed the latest source. Thanks to all helpful comments.
Change History (3)
comment:1 by , 12 years ago
| Severity: | 3 → 1 |
|---|
comment:2 by , 12 years ago
comment:3 by , 12 years ago
Yes we use the latest version, 0.8.28. I think the problem only exists in the combination SL King Oracle provider and MapGuide. If two user access the Oracle DB in parallel via the FDO Toolbox, it seems to handle the requests with a better performance.
which version of the provider are you using? 0.8.28 is the latest
http://www.sl-king.com/fdooracle/download/download.html