Jody Garnett wrote: > Long term the jdbc implementations (PostGIS, Oracle, DB2 ) are going to > be retired and replaced with a new implementation called jdbc-ng which > is faster and uses prepared statements more (for safety and speed). If > you are available to help test this work please volunteer on the user list!
Hum, I thought I alerady sent a mail on the topic, but ps make most operations accessing the whole layer _slower_ as the access plan is made on prepare, and assumes index access is faster... when you need to access the full table, that's between 2 and 4 times slower than a table scan. On the other side, when index access is a good idea, the ps make requests like wms so marginally faster that it's hard to notice, the time needed to parse and make a plan for the query is saved, but it's very small compared to the extraction of 1000s records from the database. So ps do provide safety (no sql injection possible anymore), but at a price ;-) Cheers Andrea ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
