Interestingly, it is only some of the searches. I did ten successive searches this morning, timed out on four of them, and was surprised to see that six ran from 4 - 8 seconds. I was searching for terms that I *knew* were in the DB, and wonder if there is a weakness in searching for words that aren't actually in there?
I also wrote a Perl script to perform searching, and had few if any problems. Everything was less than ten seconds, which one would expect for MySQL parsing through ~10 MB of information on a 2.5G machine with 1GB of RAM available. The rest of the server, BTW, quietly hums at less than 2% CPU, so it is not running dry from a hardware standpoint.
Methinks it may be related to the GL search algorithm, but I will certainly allow for MySQL to be the cause as well.
Your thoughts are appreciated.
Cheers.
Charles