[mapguide-trac] #500: Schema Cache performance enhancements

[MapGuide Open Source]

#500: Schema Cache performance enhancements
---------------------------------------+------------------------------------
 Reporter:  brentrobinson              |         Owner:  brucedechant
     Type:  enhancement                |        Status:  closed      
 Priority:  medium                     |     Milestone:              
Component:  Feature Service            |       Version:              
 Severity:  major                      |    Resolution:  fixed       
 Keywords:  Performance Studio Viewer  |   External_id:              
---------------------------------------+------------------------------------
Changes (by brentrobinson):

  * status:  new => closed
  * resolution:  => fixed

Comment:

 The DescribeSchemaAsXml changes make the following time difference for the
 scenario:

     - Create a feature source on an Oracle datastore with 400 tables and
 about 6000
       columns
     - Create a layer that references this feature source.
     - Execute the following on the Oracle instance:

         alter system flush buffer_cache

     - restart MG server
     - Go into Studio and open the layer.

 The following shows the times (in seconds) from when the layer open is
 started until the layer's dropdowns are populated (before and after the
 fix):

                                                         Before
 After

         Total                                           25              14
         FeatureService.DescribeSchemaAsXml part         16               7

 For the GetClassIdentityProperties changes,  the scenario checked was:

     - Create a feature source on an Oracle datastore with 1500 tables and
 500 views
     - Create 50 layers each for a different class from the above feature
 source
     - Create a map definition that includes all 50 layers
     - create a web layout on the map definition
     - Execute the following on the Oracle instance:

         alter system flush buffer_cache

     - restart MG server
     - Open the web layout on the DWF viewer
     - do a second run, opening the web layout.

 The time from when the login prompt was exited, until the legend showed up
 was taken. The following shows the times in seconds:


                         Before          After
         Run1            17              12
         Run2            11               2


 Timings were done with Studio and MG Server on a Windows XP machine ( 2.66
 GHz, 2 CPU, 3Gb RAM), accessing Oracle over a LAN. Timings may vary in
 other environments.


 Revision: 3090
 Author: brucedechant
 Date: 5:58:47 PM, Thursday, March 13, 2008
 Message:
 Fix for trac ticket 500 - Schema Cache performance enhancements
 http://trac.osgeo.org/mapguide/ticket/500

 - Submitted on behalf of Brent Robinson

 ----
 Modified : /trunk/MgDev/Server/src/Common/Cache/FeatureServiceCache.cpp
 Modified : /trunk/MgDev/Server/src/Common/Cache/FeatureServiceCache.h
 Modified :
 /trunk/MgDev/Server/src/Common/Cache/FeatureServiceCacheEntry.cpp
 Modified : /trunk/MgDev/Server/src/Common/Cache/FeatureServiceCacheEntry.h
 Modified : /trunk/MgDev/Server/src/Common/Cache/Makefile.am
 Modified : /trunk/MgDev/Server/src/Common/Cache/ServerCache.vcproj
 Modified :
 /trunk/MgDev/Server/src/Services/Feature/ServerDescribeSchema.cpp

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/500#comment:1>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals