Opened 18 years ago
Last modified 10 years ago
#1445 closed enhancement
GetFeature() not implemented efficiently for server based drivers — at Version 4
Reported by: | mchapman | Owned by: | mchapman |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | OGR_SF | Version: | 1.4.0 |
Severity: | minor | Keywords: | |
Cc: |
Description (last modified by )
The GetFeature() method of all the server based drivers do not implement random access for retrieval by feature id. Currently the drivers use sequential scans to get data which is slower than expected query times. The solution os to implement random access cursors. So far I have implemented this for PG, MySQL, ArcSDE, ODBC and PGeo. I am also going to fix Oracle and IBM Informix DataBlade.
Change History (3)
comment:2 by , 17 years ago
I would note that GetFeature() is implemented in OGRPGTableLayer, but possibly not in OGRPGResultLayer. It should likely *not* be implemented in the OGRPGLayer and that stub method should be removed allowing use of the base OGRLayer GetFeature() method. If it is implemented for OGRPGResultLayer (ExecuteSQL() results) using the cursor, care should be taken for the case where a particular column is identified as the FID as opposed to the easier case where the FID is just the index into the resultset.
comment:4 by , 17 years ago
Description: | modified (diff) |
---|
Instead of removing OGRPGLayer::GetFeature(), it forwards call to its base class (r11184).
The OGRPGResultLayer still needs implementation of GetFeature().
Note:
See TracTickets
for help on using tickets.