Jump to content


Photo

Indexing / Fulltext


  • Please log in to reply
No replies to this topic

#1 Howie

Howie
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 08 April 2003 - 09:42 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users