latency Issues

[freecity]

I am experiencing Latency issues on my website.
When some one tries to switch to another city the database takes for ever.
I am new at PHP does any one have any Idea what might be a solution.

The web site is http://www.freecitylinks.com

The link to open the city index is in the top left hand corner

I am on godaddy VDS

Thanks.

[NogDog]

No way to know for sure without any way to test or meter things, but if I had to guess, my suspicion would be some combination of non-optimal DB schema, poor SQL, and/or lack of indexes on appropriate DB fields.

[freecity]

Thanks what's a good way to test and meter

[NogDog]

You can use EXPLAIN in most DBMS's to get info about a given query. E.g. in MySQL: http://dev.mysql.com/doc/refman/5.1/en/using-explain.html