Forums

I haven't made any changes to my app for months that would affect this particular view, but today, out of nowhere, one database query is taking tens of seconds.

It just retrieves one object most of the time, and it's been working great for months. I don't know if there's something up with the MySQL database or what, but it's totally bogging my app down.

The error log isn't throwing any errors, the access log is showing 20~30 second load times just to retrieve this one view. The Django Toolbar shows that it's only one specific type of query and I haven't even touched it for almost a year.

If the table is not properly indexed and has grown in that time, that would cause queries to take longer.

Glenn,

The problem seems to have basically disappeared.

I don't know what it was, and I didn't actually change anything, but my entire database is about 24 MB and only grows by maybe 10% per year.

Thanks,

Matt

Thanks for letting us know -- if the problem returns, please let us know, preferably with timestamps when it occured.

Thanks. I will.

Matt