how to optimize or repair db tables in phpmyadmin for faster performance

[jennypretty]

Hello,
I bought a dating script online and been running it for 1 year, has about 1500 profiles, but the site is too slow now. Not about the host because I have godaddy host.
When I ask the script owner, they told me that I need to optimize the db to make tables indexed.
I already tried to go to phpmyadmin, click on all tables, then, select OPTIMIZE table from drop-down list,.... but it does not help. The site is still running too slow to load. I am using high speed intenet.

Can you plese help hot to make the site faster?

Thanks.

[Fumigator]

Doing explains on your queries would help you find columns you need to index. You offer no information concerning your database design, so we can't really help you.

[arne2]

You should add indexes to your tables. Queries often search on columns like 'id'. If you make an index for 'id' it will be able to complete it's search faster. It's like a logbook of information.
DON'T however make an index for every column as this will make your site even slower!

[guelphdad]

you should also ask a moderator to move this thread since it isn't php related. your questions are about your database.

don't over index because that will make inserts/updates slow.

the columns you want to index are those you are joining on and those you search most often.

note that you have an insignificant number of rows in your database, mysql easily handles millions of rows in a table.