Ticket #2 (closed defect: fixed)

Opened 4 years ago

Last modified 3 years ago

Improve performance related to SQL query

Reported by: ol Owned by: Ol
Priority: critical Version:
Keywords: Cc:
Triage Stage: Accepted State of Approval: Unnecessary
Attached Patches: None Complexity: Unknown
Compatibility: Unknown Specification: Unnecessary

Description

Remove useless SQL Query (on getFeature request mostly)

  • Hits and results double query
  • property type query on each feature !
  • Seek for other useless one

Change History

Changed 3 years ago by ol

Lot of redundant queries already been removed by new ows_storage mecanism,

still to refactor:

  • ows_layer_match_table in ows/ows_layer.c
  • ows_layer_storage_fill (2 request in a single one) in ows/ows_storage.c
  • remove all the remaining PREPARE stuff
  • ows_psql_column_name in ows/ows_psql,c
  • ows_psql_num_columns in ows/ows_psql.c

Changed 3 years ago by ol

And also:

  • Select localtimestamp in wfs_get_feature.c
  • Real Bottleneck one: 2 distinct queries one for gml result and one for extent result !

Changed 3 years ago by ol

  • stage changed from Unreviewed to Accepted

ows_layer_match_table in ows/ows_layer.c done as r114

Changed 3 years ago by ol

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.