Standard Works

I had a couple of people in the last week mention that the Refresh button for My Library was starting to cause timeout error messages where it didn't used to do that.

In researching the problem it was directly related to how many content items there are in the LDSScripturesApp.com's database. Most refreshes where taking around 11 to 12 seconds to complete and the timeout was only 10 seconds, so the error message was appearing.

I optimized the database and the SQL query last night taking the average query time from 11 to 12 seconds (11,000 to 12,000 millliseconds) down to an average of only .008 seconds (8 millliseconds) now. In other words, the Refresh should be much faster now.

Thanks to those who reported the slowdown! If you see anything else like that in the future, please let me know and I'll fix it ASAP.