[fdo][FDO219][New] MySQL: DescribeSchema slow for datastore opened with config ...

[Brent Robinson]

You can view the artifact detail at the following URL:

    https://fdo.osgeo.org/servlets/Scarab/id/FDO219

Type
 Defect

Artifact ID
 FDO219 (MySQL: DescribeSchema slow for datastore opened with config file)

Reported by
 Brent Robinson
 brentrobinson (brent.robinson at autodesk.com)

New artifact details:
---------------------------------------------------------

- Priority set to new value
  P2
- Version set to new value
  V2
- Defect Severity set to new value
  High
- Artifact created
- Description set to new value
  Executing a DescribeSchema command, against a datastore opened with config file, is about 13X slower that against the same datastore opened without config file.

The above would be for a datastore with about 180 tables and without FDO MetaSchema tables.
- Artifact Status set to new value
  New
- Steps to Reproduce set to new value
  - create an FdoIConnection
- called FdoIConnection::SetConfiguration, passing in a config file appropriate for the datastore to be opened.
- open the datastore via the above FdoIConnection
- execute a DescribeSchema command.

On my machine, the DescribeSchema time for a datastore with 180 classes was 19 seconds. If the SetConfiguration step is skipped, the DescribeSchema time is 1.4 seconds, 
- Component set to new value
  RDBMS
- Summary set to new value
  MySQL: DescribeSchema slow for datastore opened with config file
- Platform set to new value
  PC
- Operating system set to new value
  Windows XP
- Subcomponent set to new value
  PERFORMANCE

---------------------------------------------------------
This message was automatically generated by Project Tracker.