Indexing Tags

Home Forums Store Locator Plus Indexing Tags

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  Lance Cleveland 3 years, 12 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #12588

    az.downtown.aj
    Participant

    Is it possible to index the tags field in the SQL database to increase query speed … It is taking 30 seconds to load the results of each query.

    #12747

    Lance Cleveland
    Keymaster

    Tag fields cannot be indexed. It is a simple string field with comma separated values. Indexing that field would yield minimal if any performance gains as most people do not use a single simple text entry as tags.

    You can always index the field on your own installation using a MySQL admin tool, either via the command line or with a GUI tool like phpMyAdmin if your hosting provider gives you access to it.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.