what is the fastest way to index - full text ?

Discussion in 'MySQL' started by arambo, Jun 19, 2009.

0
  1. #1
    i want to index my 10million rows using full text

    so what is the best way to do this ?

    i am using mysql

    doing this using (sql command) takes something like 3 days :) - this is crazy so if you have have a better way please tell me

    maby if i switch to mssql ? i can index faster
    thanks
     
    arambo, Jun 19, 2009 IP
  2. nirajkum

    nirajkum Active Member

    Messages:
    815
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #2
    well index on the primary key ... I think which must be integer ..... this is how I do ... still 10million rows is a huge data and it will take 3-4 hours to do the operation
     
    nirajkum, Jun 23, 2009 IP