I'm setting up an autocomplete script (http://interface.eyecon.ro/demos/autocompleter.html) and i'm trying to determine the best method for storing the "auto complete" values... This will be for keywords, so I could do just a one row table that could have hundreds of millions of records, I could store it in a text file..... What do you think would be the fastest method for doing this and if using mySQL, should I use like% or regex?
Thanks!
Query for auto-complete
Moderator: General Moderators