Hi,

For all who have been following my slow query dilemma, it looks like the problem
is something on our server.

I copied the database from our server to my desktop development PC. Now with my
PC as our software server, I logged into the user who has 7000 mail messages and
his mailbox loaded in under 3 seconds.

I then did the same test, from our proper server, and the same query took 30
seconds, I did both tests local on each machine.

So it looks like something on our server is seriously slowing it down. Our
server hard disk is fairly new, a 180Gb Seagate. With losts of space left. Our
server is also a Norton AntiVirus Server, maybe the virus software is scanning
the MYSQL data files as its being read?

Does anybody have any other ideas what could be slowing down the query on our
server so much?

Our server is not really used for anything else that is intensive. It also
serves about 20 mailboxes and a few quiet websites...

Thanks Greg