Over the holiday weekend, browsed through the database for this site and cleaned up a lot of old/unneeded information. Set a limit of 100 messages in the private message inbox, as well as sent items. If you haven't looked at either your inbox or sent recently, please do so so the system will truncate the old messages automatically.
ucp.php?i=pm&folder=inbox
ucp.php?i=pm&folder=sentbox
Removed the statistics in the photo gallery that showed where people were being referred from to view pictures. The view count is still there, but this referral information was taking up lots of database space. Reduced the database from 460 megs down to 340 megs. Also ran some optimization software to clear out blank or errored lines. This all may help keep posting times, searching, and pulling up threads a bit faster.
Cleaning databases
- ~Z~
- Sofa King Admin
- Posts: 13007
- Joined: Tue Oct 12, 2004 2:14 pm
- Location: Grand Rapids, MI
- Contact:
Cleaning databases
Webmaster
Railroad photos on Railroadfan.com
Railroad photos on Railroadfan.com
- Saturnalia
- Authority on Cat
- Posts: 15415
- Joined: Wed Sep 28, 2011 7:54 pm
- Location: Michigan City, IN
- Contact:
Re: Cleaning databases
I've noticed the changes, an I'm getting a slightly faster speed. Its really nice to have a webmaster who stays on top of things. The most annoying thing is when you send someone an email, and it FINALLY comes back a week later
Excellent job ~Z~!
Excellent job ~Z~!
Re: Cleaning databases
Noticed it too! Nic work zack
"Ann Arbor 2373 Calling... Milkshake. Over"
All Aboard Amtrak: Northbound, Southbound, and My Hometown
All Aboard Amtrak: Northbound, Southbound, and My Hometown