Hi, today I stumbled upon another reason for having hints in queries (or in trasactions, I still have to look into it to have an opinion on which one is better). I was getting OOM trying to build a map with WMS getting data from Postgis. We do have a fetch size of 1000 in all JDBC data stores, which is good for small sized geometries,but in my case a layer had coastlines, very very big, and 1000 features could not fit into the standard heap. Fetch size should become one of the "well known" hints for queries imho.
Cheers Andrea ------------------------------------------------------------------------- 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-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
