[fdo][FDO194][New] RDBMS providers: Unnecessary constraint queries for List Dat...

[Dan Stoica]

You can view the artifact detail at the following URL:

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

Type
 Defect

Artifact ID
 FDO194 (RDBMS providers: Unnecessary constraint queries for List Datastores command.)

Reported by
 Dan Stoica
 danstoica (dan.stoica at autodesk.com)

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

- Artifact Status set to new value
  New
- Steps to Reproduce set to new value
  Set FDO_TRACE_FILE=...

For the List Datastores command, the trace file shows a number of unique and check constraint queries being executed. However, this command does not need constraint info.

Similarly, for the FdoISelect command, the trace file shows a number of constraint queries, including some for retrieving constraints for OWM-enabled tables. 

Constraint retrieval is expensive and is only needed by the DescribeSchema command. Performance gains can be realized by avoiding these queries when executing other commands.


- Artifact created
- Description set to new value
  List Datastores comand is extremely slow.
- Summary set to new value
  RDBMS providers: Unnecessary constraint queries for List Datastores command.

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