Thanks peter, good to hear!
For those that are curious, non indexed means doing a search like '%some term%'. It is very simple to do, however mysql needs to search every single row in the database. Even mysql takes awhile when doing this.
Links SQL indexes the words in a series of tables to optimize speeds, and never has to do a full table scan.
Cheers,
Alex
For those that are curious, non indexed means doing a search like '%some term%'. It is very simple to do, however mysql needs to search every single row in the database. Even mysql takes awhile when doing this.
Links SQL indexes the words in a series of tables to optimize speeds, and never has to do a full table scan.
Cheers,
Alex