How to index my tables for Phoenix

[JoshuaLuke]

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]

You must be registered for see links

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]

You must be registered for see links

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?

 

[Gajeel]

Maybe all? Since you wanted your whole hotel to speed up I bet.

 

[JoshuaLuke]

Maybe all? Since you wanted your whole hotel to speed up I bet.

Mm Ok. Does anyone have a MySQL query to do all of this for me?:3

 

[Gajeel]

Mm Ok. Does anyone have a MySQL query to do all of this for me?:3

You better read the link I gave you, there are syntaxes over there, might be helpful.

 

[Sledmore]

Simple, Navicat > CTRL + D > Indexes, pow.