Jump to content
Updating IPB tonight Read more... ×


This topic is now archived and is closed to further replies.


Indexing / Fulltext

Recommended Posts

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. :?:

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.