Page 1 of 1
Faster AJAX Database Searching
Posted: Wed Apr 01, 2009 2:01 pm
by icesolid
I wasn't sure where to post this one, scold me if I am wrong.
I am just wondering if there is any way of making an AJAX database search on every onkeyup, bring up the results faster?
Re: Faster AJAX Database Searching
Posted: Wed Apr 01, 2009 2:16 pm
by php_east
icesolid wrote:I wasn't sure where to post this one, scold me if I am wrong.
I am just wondering if there is any way of making an AJAX database search on every onkeyup, bring up the results faster?
faster than what i don't know, but i was told google does that in google suggest. works fine.
Re: Faster AJAX Database Searching
Posted: Wed Apr 01, 2009 2:18 pm
by icesolid
Google does what in Google suggest?
Re: Faster AJAX Database Searching
Posted: Wed Apr 01, 2009 2:27 pm
by php_east
does what you asks...
icesolid wrote:......making an AJAX database search on every onkeyup.....
Re: Faster AJAX Database Searching
Posted: Wed Apr 01, 2009 2:28 pm
by icesolid
I have coded my own AJAX search onkeyup. The problem is the search results come back slowly, I am wondering how I can speed up the retrieval of results.
Re: Faster AJAX Database Searching
Posted: Wed Apr 01, 2009 2:45 pm
by php_east
well, we cannot do anything much about interconnect speed, so the next best thing is to ensure we don't have to load an entire framework just to access a few db table values, if that is what you are suffering from.
it guess it depends on exactly what search is done, for google, it is just a matter of the popular keywords within the context typed, and that plus the fact they have fast localised servers everywhere makes it relatively fast.
another way is perhaps to load a portion of your db, if not large, onto a hiden frame and search on that frame. that would really be fast.
Re: Faster AJAX Database Searching
Posted: Thu Apr 02, 2009 3:13 am
by Mark Baker
Rather than searching the database directly, you might consider a
Trie search