1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Most Efficient Way To Store Keyword Searchable Data

Discussion in 'MySQL' started by mjda, Mar 12, 2013.

0
  1. #1
    As the title says, I need to know what some of y'all think is the best way to store large amounts of keyword searchable data.

    At the moment I'm thinking of storing that data as TEXT with a FULLTEXT index, and searching it with boolean searches. Is there a faster and/or more efficient way of storing and retrieving this data?

    By the way, there will be millions of records in this database.
     
    mjda, Mar 12, 2013 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    It depends on the nature of the data. There's no one most efficient way for all data.
     
    Rukbat, Mar 15, 2013 IP
  3. goproxy

    goproxy Member

    Messages:
    52
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    26
    #3
    I prefer VARCHAR than TEXT, but there's no big performance difference.

    Regarding the index, you should use a HASH type index if you're going to select by exact match keywords or a BINARY TREE type if you're going to select keywords by ranges, like keywords starting with 'a' or things like that.
     
    goproxy, Apr 30, 2013 IP