[gdal-dev] RE: Optimizing random access in SQL result set of OGR DB drivers

2009-08-26 Thread Martin Chapman
Even, I agree with your response. Regardless of specific implementation I think your efforts to provide high speed random access searches by ordinal position for the database drivers will be a fantastic addition to the OGR library. I am really excited to check it out when you get it ready for tes

[gdal-dev] RE: Optimizing random access in SQL result set of OGR DB drivers

2009-08-26 Thread Even Rouault
Selon Martin Chapman : > Even and Frank, > > 1. I would absolutely not change any existing functionality of how FID is > handled or you will screw up everyone's code that depends on that and will > cause a lot of people serious grief. > > 2. I cannot remember exactly but I think SetNextByIndex w

[gdal-dev] Re: Optimizing random access in SQL result set of OGR DB drivers

2009-08-26 Thread Even Rouault
Selon Frank Warmerdam : > Even Rouault wrote: > > Martin, > > > > I take the liberty to CC the list, as it is an interesting issue and it's > better > > to go public if we want to make progress on that. > > > > In a few words, this is about how we could speed up GetFeature() on the > layers > > re

[gdal-dev] RE: Optimizing random access in SQL result set of OGR DB drivers

2009-08-26 Thread Martin Chapman
Even and Frank, 1. I would absolutely not change any existing functionality of how FID is handled or you will screw up everyone's code that depends on that and will cause a lot of people serious grief. 2. I cannot remember exactly but I think SetNextByIndex was intended to solve this problem

[gdal-dev] Re: Optimizing random access in SQL result set of OGR DB drivers

2009-08-26 Thread Frank Warmerdam
Even Rouault wrote: Martin, I take the liberty to CC the list, as it is an interesting issue and it's better to go public if we want to make progress on that. In a few words, this is about how we could speed up GetFeature() on the layers returned when issuing a SQL request on OGR drivers that r