SCF Slow To Load At Times

Very hit and miss for the last several months. Particularly difficult to connect today. All other websites load just fine.

Oy vey was a bear tonight. First 3 tries to log in lasted over 8 minutes before I gave up. Just got in now, quickly.

Yes, a tough night indeed.

Ok, I think I may have it fixed. (fingers crossed)

I ran some tools on all the DB tables, repair and optimize.

But I think the real culprit was this....

Many years ago we had some performance issues so we added some code to record page urls/load times/time of day etc. So each page load added a row to the DB table so we could analyze things. We figured out the issue and fixed it, but never disabled the code. So this table now had almost 100 million rows in it! I removed the code from the site and deleted the table. The DB almost instantly went from about 100 million rows to about 900 thousand.

I noticed an immediate increase in pageload times and haven't had a slow one yet, but it's only been around an hour so far.

Thanks Bobby. Much appreciated.

The difference today is extraordinary.

Been there, done that. Legacy code, gotta love it. Site feels very responsive now.

Super fast so far...well done!

I got an "error processing page" this morning when I made a post. The post was successful but did not return to the view after posting.

Added:
For this update(not the first one), it took 3.54 seconds to lick this stamp so some delay.

Its not slow anymore, pages are loading quickly now!

I have had super speed today.

I have also noticed a significant improvement in response today.

I still see occasional issues with very slow loading. Sometimes I get an error like "error processing page" in big red characters

Seems to be off and on, some days fine and other days awful.

Yes, I am having issues again.