Howie Posted April 8, 2003 Share Posted April 8, 2003 I have a database of 500 properties. A listing produces 30 properties per page (with no photo) is getting very slow to load. It produces a list returning properties betwen a price band for a specific country and sorted by price. I would like to improve performance. A Primary index is used. Is the Primary for one field or combination of fields. How do I use phpadmin to change? I do not understand how the primary / index / fulltext are set, and how they differ. Do I need to index on price, and country? Or Fulltext or change the Primary? I am a complete newbie on this - any help on the differences and how to set them in phpadmin much appreciated. :?: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.