Jump to content

Indexing / Fulltext


Howie

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

Link to comment
https://forums.phpfreaks.com/topic/321-indexing-fulltext/
Share on other sites

Archived

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

×
×
  • Create New...

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.