:: 08-Mar-2002 02:49 GMT (Friday) ::
And there was much rejoicing.
Sybase 11.0.3 can’t optimize stored procedures very well, which was causing a
problem for the participant history page. Every time someone hit that page, it
would cause the database to read a substantial portion of the (now 52 million
row) Email_Contrib table. Not only would it take forever to get that page back,
but all of that disk IO was seriously impacting the server itself.
Anyway, I’ve replaced the stored proc with a raw query (so much for code
abstraction), and everything seems to be running OK again.