Christian Müller wrote: > There is another impact when using > toLowerCase(myAttribute) LIKE 'blah%' > The use of a toLowerCase or toUpperCase on an sql column will prevent > using sql indexes. The result will always be a table scan which hurts on > large tables. > I think this fact should be considered too.
Very true. There are sure better ways to do it considering a datastore per datastore case, what I needed was a quick solution that worked on small data sets. If you need a high performance one implement native support for it by following the path I described before (extend the interfaces to add matchCase to Like filters, change filter parsers, the sql encoders, and so on). 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-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
