Freedom Aerospace is one of our newest launches for Curiosity Media. The site took around 3 months to develop, and it is the first site to tackle a database that contains 7 million plus records of just airplane parts information. The challenge was to find a way to retrieve a 7 million record database and not bog down the servers processing.

Mysql database is not always the best choice if you want a huge database of records. But although it’s not perfect, the best way to improve performance is to carefully choose your indexes for each table. You also need to find creative ways to partition, or break up these records. Unfortunately I recently figured out how to further improve the efficiency of data retrieval. ‘Apache Lucene’ is the key to this, and I wish I had known this sooner, because I think the server that is hosting Freedom Aerospace doesn’t have Java support. And for those of you who thinks Java is just another delicious hot drink, well it’s actually a powerful programming language.

Although Freedom Aerospacecaters to the high tech world of the aeronautics industry, if you are working at a company that needs some great deals on airplane parts feel free to pass along the news about Freedom Aerospace.

I’d also like to get some input on what you guys think about this new site?

More from Curiosity Media

• Wedding Photography Nightmare
• 2009 OBAMA’S Inauguration
• Use Apache Solr for Lightning Fast Database
• Official Launch of Cheebras
• True Relgion Brand Jean’s Site Launch

Curiosity Media Recommends

• Project Freeze: The Art of Drinking from a Fire Hose  (Full Speed SEO)
• Google Chrome OS Programming  (gravityjack)
• It’s A Girl Thing???  (Steven Leong’s Blog)