Re: [Geotools-gt2-users] UniqueVisitor and sorted and paged queries

[Andrea A. <and...@ge...>]

On Thu, Apr 17, 2014 at 1:03 PM, César Martínez Izquierdo <
ces...@gm...> wrote:

> Thanks Andrea for the pointer,
>
> Those improvements on JDBCDataStore do not seem complicated, but then the
> code I wrote will behave inconsistently depending on the underlying data
> source (well, maybe it is inconsistent also with current implementation).
>

Yes, that might be the case, although JDBC data store is the only one I'm
aware of that optimizes the visitors out, all the others run them fully in
memory.
Sorting is also not always supported from all data stores.


>
> My current approach to get consistent is to sort and page the result after
> applying the visitor, thus skipping any database improvements for sorting
> and merging.
>
> Any other suggestion?
>

Nope

Cheers
Andrea


-- 
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------