Hosting has disabled my database.

Have purchased a lyrics database from this forum, but my host has informed me the MYSQL database queries are too intensive, and have disabled them.

Is there an easy fix to the above? Sorry but i know nothing of MYSQL

Would greatly appreciate any help.

 

You have to get someone who knows SQL to do it for you. Your database structure needs to be changed. After you do that you'll have to change the script you're using to support the new database structure.

 

Who were you hosting with? I know Hostgator shut down sites for having too-intensive databases.

 

Guess i will need to head over to one of the freelance sites..

Host for this website, is dreamhost..

 

You just need an index on column 'artist'.

 

You will need to full text more than artist, unless the artist field is the only one to query.

You can try this: $q=artist

$query = "SELECT Lyrics.* ";
$query .= ",MATCH(artist) AGAINST (' . $q . ' IN BOOLEAN MODE) ";
$query .= "FROM Lyrics ";
$query .= "WHERE MATCH(artist) AGAINST (' . $q . ' IN BOOLEAN MODE) ";
$query .= "Order BY Title ASC ";
$query .= "LIMIT 0 , 25 ";

 

if your host will run it - i've heard good things about the sphinx fulltext search engine. I have similiar issues with the fulltext searches on our site. And its indexed as well and on a clustered host. it still crashes some times.