Home » Community Blog » Publisher's Desk

Neat and Tidy

By Michael Ricci
October 10, 2023
1,076 Views

Back in August we completed an effort to clean up our database. It was long overdue. We had thousands of deactivated records that were taking up space and our goal was to ensure our db remained squeaky clean and optimized moving forward. When all was said and done, the clean-up resulted in the removal of 207,641 records spanning 43 tables reducing the size of our database by 2%. Amazing, and it just goes to show you how massive AAJ is... we shed over 200,000 records and our database shrunk by only 2%. Still, it feels good to be neat and tidy.

Here are our totals as of October 10, 2023:

Articles (including Album Reviews)

78,810

News Announcements

68,362

Albums

146,608

Musician Pages

136,827

Venues, Festivals and other Local Businesses

56,432

Members

219,401

Newsletter Subscribers

85,201

Photos

232,505

We recovered over 3,000 articles from our 2003 crash and are slowly adding them back to the database.

Posted to Publisher's Desk IN THE All About Jazz GROUP
Read more posts by Michael Ricci

PREVIOUS / NEXT

Event Imports & Venue Clean Up - A T...
< Previous

Venue? Export your events to Jazz Ne...
Next >

Comments

Support All About Jazz

All About Jazz has been a pillar of jazz since 1995, championing it as an art form and, more importantly, supporting the musicians who make it. Our enduring commitment has made "AAJ" one of the most culturally important websites of its kind, read by hundreds of thousands of fans, musicians and industry figures every month.

Go Ad Free!

To maintain our platform while developing new means to foster jazz discovery and connectivity, we need your help. You can become a sustaining member for as little as $20 and in return, we'll immediately hide those pesky ads plus provide access to future articles for a full year. This winning combination vastly improves your AAJ experience and allow us to vigorously build on the pioneering work we first started in 1995. So enjoy an ad-free AAJ experience and help us remain a positive beacon for jazz by making a donation today.