Page 1 of 1

Query for auto-complete

Posted: Mon Aug 06, 2007 12:52 pm
by GeXus
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!