[mapserver-users] MapServer Oracle performance

[Michael Shishcu]

Bart, Andy, thanks for the answers

Andy, here is a brief explanation of the bind variables:

http://www.akadia.com/services/ora_bind_variables.html
http://www.oracle-base.com/articles/misc/LiteralsSubstitutionVariablesAndBindVariables.php

the idea is to have a query pre-parsed and to substitute parameters in this
query, so to make the Database think that the query is the same even if
there is difference in "where" clause.
Tomorrow I'll make some benchmarking for a real life example.

Bart, about patching, I'll try to find out a solution

regards, michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090827/4b34675a/attachment.htm>