[Catalyst] How to detect cancelled requests?

[Peter Corlett]

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.