Query for auto-complete
Posted: Mon Aug 06, 2007 12:52 pm
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!
Thanks!