How to index my tables for Phoenix

JoshuaLuke

Posting Freak
Jan 29, 2012
529
51
Hi.

I realise that indexing your tables for your MySQL database make your retro less laggy, I would like to index my tables but I don't know how, or what to index.

Has anyone got a MySQL query or some information/guide to do all this for me?

Thanks
Josh
 

Gajeel

Well-Known Member
Oct 4, 2011
2,411
413


That should help alot, it explains what MySQL indexing is, and it might make your retro less laggy speeding up the site due to indexing the datas on your database thus lessening the time MySQL has to read the first row up to the last. ;)
 

JoshuaLuke

Posting Freak
Jan 29, 2012
529
51


That should help alot, it explains what MySQL indexing is, and it might make your retro less laggy speeding up the site due to indexing the datas on your database thus lessening the time MySQL has to read the first row up to the last. ;)

Which tables would I need to index?
 

Users who are viewing this thread

Top