Upgrade to 5.1 causing marked slowdown in appointment module

[mowgli]

Using version 4.9.13 with a large database (4 dentists with 2 ops each, and 3 hygienists, 100mb in size) it took only a second or two to move from day to day in the appointment screen. Now on v5.1.19 with the same database, the current day's appointments hang in the screen for about 8 seconds before the next day's appointments appear. On slower PC's, it's even worse, up to a minute. Using 4.9, MySQL (mysql-nt in process list) takes about 14% CPU usage to load the appointments, but on 5.1 it takes nearly 100% of CPU. Slowdown occurs on both MySQL 4.1 and MySQL 5.0. On another database, 65mb, it takes just a couple seconds, so it doesn't seem to occur on all databases. I'm wondering if anyone else has had a similar experience and was able to resolve it, since I'm very reluctant to upgrade this office to version 5.1, and perhaps also other offices with large databases. Thanks for any ideas.

[jordansparks]

I got this complaint last week but could not duplicate it. We have to have a database to troubleshoot. So they have two very simple choices:
1. Live with the slowness.
2. Let us have a copy of their database.
It's their choice.

[drtech]

I had this same problem...I found that running a database maintenance fixed it on my database. You could try that. Not sure what it was that it fixed, but it worked for me.

[mowgli]

I had this same problem...I found that running a database maintenance fixed it on my database. You could try that. Not sure what it was that it fixed, but it worked for me.

Thanks for the suggestion. I did indeed try that fix before posting.

[mimai]

We had similar massive slow down after upgrading to 5.0 and the to 5.1.
After the appointment module was optimized for speed in version 5.2, the problem is gone. Thank you Dr. Sparks.