Visitor Messaging query takes AGES to complete...

[MrEyes]

Without rewriting the code that pulls out and renders the VM's I believe the only option you have is to purge out some of the older messages.

Unfortunately I do not think that there is an ACP function for this so unless somebody else can point one out you are going to have to do this in the DB.

I would strongly suggest trying it on an offline backup DB before running it on live.

If you want to be really adventurous you could create an ACP scheduled job to clear out all VM's older than X days every night.