I have been using UddeIM for about 6 months... Perhaps longer...
The more messages in the UddeIM database the slower the site went and the more the server had lag... But not like one second of lag, at this point I can click inbox, and have to wait ten or more seconds before It loads.
I had similar issues with MyPMS Pro before it went to Clexus, except that the problem was during sending messages...
My site has over 31,000 + members, and gets ALOT of traffic..
I have TWO dedicated servers, one for MySQL, and one for HTTPD, and I STILL experience this horrible lag...
When I check the slow query log, MOST of the slow queries are from UddeIM..
I have tried to optimize the queries in the UddeIM code, and where appropriate I have set the queries to "LIMIT 1" to make sure it doesn't keep searching for more matches once it's found what it's looking for.
I have also tried turning OFF user Avatars and unfortunately it's still horribly slow...
I know there has got to be a way to fix this problem, but I just don't know where else to search!
Any help would be greatly apprecaited!