Ajax - Auto suggest drop down box. How to reduce Database overheads?
Posted on 2008-10-17
Right now, we are developing a system with which the results are displayed real time via AJAX. What happens is that as user is keying in a value in the textbox, the results are displayed accordingly and is changed immediately based on what is keyed-in.
This in turn will cause a huge database overhead in a heavy traffic enviroment.
Most of the queries are
select col1, col2 from table1 where col3 like '%something%'
Are there any better ways to implement this?