On Wed, Oct 29, 2008 at 10:11:35AM -0400, Stuart Watt wrote: [...] > To give context, the queries that are an issue are SQL queries against a > database that contains millions of components, where users may construct > wildcard queries of the form "*A*", with additional filtering constraints.
If that was a reasonably popular query, I would certainly consider building a table which contains substrings of that field, so that it becomes a much more optimisable "LIKE 'A%'" query. _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
