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? Link to comment https://forums.phpfreaks.com/topic/100589-querying-large-mysql-databases/ Share on other sites More sharing options...
fenway Posted April 11, 2008 Share Posted April 11, 2008 Did you index it? Link to comment https://forums.phpfreaks.com/topic/100589-querying-large-mysql-databases/#findComment-514833 Share on other sites More sharing options...
mwasif Posted April 11, 2008 Share Posted April 11, 2008 Read the sticky to optimize performance. Link to comment https://forums.phpfreaks.com/topic/100589-querying-large-mysql-databases/#findComment-515054 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.