Ok here the problem, our server is so slow during peek usage, i'm wondering if there a way to optimize these query. We are currently using 1 big table called members.
1st query: When they browse member.
select account, fname, age, countvote, median, lastlogin from members where review like 1 and age >= '$agemin' and age <= '$agemax' and sex like '$sex' ORDER BY joindate DESC
2nd query: When they look at the member page
select password, fname, age, country, height, weight, town, eye, hair, homepage, email, hobbies, more, showemail, review from members where account like '$account'
3rd query: the search engine
select account, age, fname, town, country from members where review like '1' and fname like '%$searchfname%' and age >= '$agemin' and age <= '$agemax' and sex like '$sex' and town like '%$searchtown%' and country like '%$searchcountry%' and more like '%$searchmore%' and hobbies like '%$searchhobbies%' ORDER BY joindate DESC
Those are the most often use query so if there a way to optimize them, I'm sure it could help.
Thanks a lot
1st query: When they browse member.
select account, fname, age, countvote, median, lastlogin from members where review like 1 and age >= '$agemin' and age <= '$agemax' and sex like '$sex' ORDER BY joindate DESC
2nd query: When they look at the member page
select password, fname, age, country, height, weight, town, eye, hair, homepage, email, hobbies, more, showemail, review from members where account like '$account'
3rd query: the search engine
select account, age, fname, town, country from members where review like '1' and fname like '%$searchfname%' and age >= '$agemin' and age <= '$agemax' and sex like '$sex' and town like '%$searchtown%' and country like '%$searchcountry%' and more like '%$searchmore%' and hobbies like '%$searchhobbies%' ORDER BY joindate DESC
Those are the most often use query so if there a way to optimize them, I'm sure it could help.
Thanks a lot