Opened 11 years ago

Last modified 11 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 sgamperl, 11 years ago

Severity: 31

comment:2 by zspitzer, 11 years ago

which version of the provider are you using? 0.8.28 is the latest

http://www.sl-king.com/fdooracle/download/download.html

comment:3 by sgamperl, 11 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.

Note: See TracTickets for help on using tickets.