Day: September 2, 2022

So the site seemed to be working very smoothly. I started with a fresh database, so everything was lost. The restore I attempted only restored posts/comments up to 2010. So I started running SQL queries to restore the lost posts. At some point I got a majority of them back.

But then I noticed the site loading very slowly. I watched the sql process eat up the server resources.

Unfortunately I’ve come to the conclusion that the data in the database is just too large storing all the data. There’s 15 years of posts an comments in there, and it’s choking the site.

Hence, I’m going to remove older from the database. I’ll keep only the X most recent years, which at this time will be 10 years. If that stabilizes the site, I can keep them. Otherwise I’ll keep reducing it by a year, until I find a sweet spot.

My thinking right now is this: Keeping the site running smoothly so that people can read/post is more important than the old stuff. I still have the old database, so theoretically I can do something with it. Perhaps make some static pages. But that’ll be a future project.

Fingers still twisted…

OK I’ve opened up site registration, and the ability to comment. Feel free to give both a try.

Note: You’ll have to verify your account by email. Check your email spam, because that’s where mine went. If you ever published an article, you might already have an account & may have to reset the password.

I’ll try to check in regularly during the day & there’s still a ton to do on the back-end. Fingers still in a know.

Hey everyone. I know you’re all excited to talk about the Cavs new guard, but I need a little more time to get the site up. I tried my best to get it all up today, but it’s not happening.

In all likelihood everyone might have to create new accounts, and hopefully it should be up some time tomorrow.

Fingers still crossed.

Wow, so this is weird, huh?

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!