:: 05-Jan-2000 03:06 (Wednesday) ::
Well, we’ve finally got the load on statsbox under control again
*knocks on wood*
The problem seemed to be with the participant search script again.
(This is what caused the massive slowdown last time too). The
problem is that in order to allow the most flexible search
possible, the script would search for the string entered anywhere
in the email field. (“*string*”). Unfortunately, Sybase can’t
optimize this query, and it was killing the box. (The data-servers
were using over 80% CPU almost constantly… when the psearch
scripts were down, usage was rarely over 60%).
So, the script has been redone a bit. First, if there’s an @ in
the search term (such as when looking up a complete email
address), the script will attempt to do a “string*” search first,
which Sybase can optimize. If that fails (or if there’s no @),
the script will do a “*string*” search like before, but it will
only retrieve a list of IDs, which it will then use to look up
participant info for the specific project. This is a somewhat in-
efficient way to do things, but it’s brought the load under
control. The only functional difference will be if you try to do
a partial search using a string with @ in it. You’ll end up searching
on “string*” instead of “*string*” like the script used to.
I have a feeling we’re going to be needing faster CPUs in the near
future… anyone want to buy the PII-300s we’re using for a
keepsake? }:8)
One other note… if you typically do a search on your email, you
might want to bookmark your summary page instead… it will come
up faster if you don’t go through the psearch script.
Sorry for the downtime and errors while I was debugging. Everything
seems to be working now.