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. :?: Link to comment https://forums.phpfreaks.com/topic/321-indexing-fulltext/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.