Hey, Hoping someone can point me to something I've missed...
I need to use an attribute besides a FID to track features but I'm running into a problem when I have a large number of identifiers (think 50000+). When I translate from FIDs to identifiers it's not a problem because the FidFilter has been optimised (using an SQL IN clause for the databased I've used so far anyway) to perform pretty well. So in this case I've just used a Query to retrieve the attribute I'm interested in for a given list of FIDs. The problem I have is when I need to go the other way. I need to go from the identifier list to a FID list before I can perform my spatial operations, and the only way I can see to do this is to create a CompareFilter for each identifier and combine them all with a bunch of LogicFilters and try and use this in a Query to retrieve the FIDs, but unfortunatly the SQL generated for this is anything but optimised, and if the list is large enough can't even be created because of recursion problems. Is there another way to do what I'm after? Currently I'm using GT 2.3.1, but I think the issue may be the same for 2.4. Is it an option to create a custom filter? Some sort of variation on the FID filter which uses a specified attribute rather than the FID attribute? And would this involve having to modify every DataStore plugin? Cheers, Shaun ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Geotools-gt2-users mailing list Geotools-gt2-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
