chrischen Posted April 11, 2008 Share Posted April 11, 2008 I downloaded MusicBrainz.org's database and imported it into my mysql database. It has approximately 6million rows of song data. When I try querying it it takes forever. However on the MusicBrainz site (they use Postgre) its really fast. How do I structure the database to get this speed? Quote Link to comment Share on other sites More sharing options...
fenway Posted April 11, 2008 Share Posted April 11, 2008 Did you index it? Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 11, 2008 Share Posted April 11, 2008 Read the sticky to optimize performance. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.