Freeform text searches are kind of expensive to start with, when you're not doing anything in particular to speed them up (like periodically dumping every "word" of a poem/comment into some sort of lookup table). There are a lot of long poems and long comments in the database.
Then again, a search for 'the' (matches tHe and TheRe) gives 38,634 hits in the span of 939.89 msec. That's not so bad, really. The next question would be how to sort and page through those, but I could do something 'stupid' easily enough (like sorting by date entered into the system, showing up to... 100 results at a time or something).
Hmm.
|
