Account Module loads very slow

[mvoschin]

Just updated to 5.6.20.0
Depending on the account history length when clicking on the module loads(almost hangs) very long. Tried the database on a different computer including database maintenance - same result. There is a waiting time of about 10-30 seconds.

[jordansparks]

Hmm. It must be database specific, because I noticed to lag time at all. Any chance we could get a copy of your database so we can try to pin down the slowness? I'm sure it won't be too hard to find if we have a database. We probably just need to add an index on some column.

[mvoschin]

Where can I upload the file? I used Navicat, so would *.psc backup file work or do you need the whole sql dump? Since we are on the speed topic, is there anything that can be done to speed up load time for Procedure Codes?

[jordansparks]

Neither .psc nor sql dump would be useful to us. The actual database files are what we need, typically zipped into a single file. We had used MediaMax in the past, but they just shut down. So we are working on getting our own ftp site up and running. Until then, we can grab it directly from your computer over a remote connection.

[drtech]

another report of speed:
- my account module is less than a second and same with procedure codes...

so what is it that would cause such a slowdown in some databases Jordan? You mentioned an index or column...is that when a database reaches a certain size it needs faster indexing or something?

[jordansparks]

Example: User converts from another software and brings over 500,000 commlog entries. If a typical database had only 5000 commolog entries, then that would be a magnitude of difference of 100 times. That would be noticeable if indexes were not set up right. Larger databases will experience slowdowns before smaller databases. But once we notice a slowdown, we can tune it and optimize it to be faster.

[jordansparks]

OK, msvochin. I have your database up and running on my computer. The account module runs nice and fast. Any patient in particular that seems to be slow? Oh wait. I found some that are taking 4 seconds, and that could be longer if it's over a network.

[jordansparks]

I'm making progress. I have isolated a query that seems to account for most of the slowness.

[mvoschin]

I have noticed that it also depends on the speed of the computer. I was thinking of switching to Gigabit Ethernet but the operatory laptops don't have the GbE port . I just don't want to upgrade to dual/quad core just to run the database.

[jordansparks]

No, you don't have to. It's running at least 10 times faster now.

[jordansparks]

To get the speed increase, you'll have to upgrade to version 5.6.22, which has not yet been released. Hopefully tonight.

[mvoschin]

Just upgraded to 5.6.22; delays are about 1-2.5 secs. Thank you for a quick response.

[jordansparks]

It should be well under a second. I will review all the queries on that page for possible missing indices.

[kapricorn]

We also have a client that is experiencing the same problem, converted them from softdent and they are on 5.6.23 and still extremely slow 10 seconds across the network. We have a copy of the data we can put on our ftp site if you wish.

Thanks,
Curt

[jordansparks]

We're working on it today and tomorrow. I think we have a database we can use to duplicate the slowness. If not, we'll contact you.