Hi Karsten,
> Question seconded (and tacit suggestion for a TODO item) on
> behalf of GnuMed (www.gnumed.org).
Depending on how your LIKE searches look like, you can use a little work
around, which improves speed dramatically. In case you need to search like
"<String>%", you can use a second table containing each possible
combination of the search string, a fixed length field and JOIN that
helper table.
So you can change your LIKE search to a search for a string of fixed
length.
Kind regards
... Ralph ...