Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#4839 closed enhancement (fixed)

Improve FGdbDatasource to use API Geodatabase::ExecuteSQL

Reported by: jpalmer Owned by: Even Rouault
Priority: normal Milestone: 1.10.0
Component: default Version: svn-trunk
Severity: normal Keywords: FileGDB SQL ExecuteSQL
Cc:

Description

It would be really good to change the current implementation of FGdbDatasource::ExecuteSQL to pass calls to the FileGDB API Geodatabase::ExecuteSQL() by default. This would then take advantage of the Esri FileGDB SQL engine.

Apart from the obvious speed enhancements you would gain by using this method, users would also get the ability to create table indices. e.g

ogrinfo -sql 'CREATE INDEX my_table_id_idx ON my_table (id)' myfile.gdb

Change History (2)

comment:1 by Even Rouault, 12 years ago

Resolution: fixed
Status: newclosed

trunk r25025 "FileGDB: use File GDB SDK API for SQL statements. Note that due to to partial/inaccurate support for SELECT statements in current FileGDB SDK API versions (v1.2), SELECT statements will be run by default by the OGR SQL engine, unless the FileGDB dialect is explicitely specified (#4839)"

comment:2 by jpalmer, 12 years ago

Wow Even! Works fantastic. Thank you very much.

Note: See TracTickets for help on using tickets.