This topic is locked

Ajax in Quick Search Slow

6/10/2007 9:04:53 PM
PHPRunner General questions
P
phpwalker author

since upgrading to php runner 4 ... the searches in my application have slowed to a crawl...
I have a mySQL database with about 600,000 records... with the new php runner, the quicksearch area has an ajax drop down that appears to be used to add auto-suggest functionality... this is DEAD slow... is there any way to turn this off?
or is there something I am missing here?
as further explanation... i have a table of contact (about 300,000) ... when i try to search on LastName Equals (whatever) ... it takes a little while (seconds) for the auto-suggest to catch up with the typing ... starts with a long list then eventually (again, after a few seconds) narrows this down to the particular name... even when I know exactly which name i want to search for (and don't need the auto-suggest) ... it seems i have to wait for the auto-suggest feature to finish before the actual search is executed.
sidenote: the same quick search in the prior version 3.1 ran VERY quickly...
any help would be greatly appreciated,
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5476&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />

Sergey Kornilov admin 6/10/2007

To turn off AJAX set $useAJAX variable in include/dbcommon.php file to false.
If you like me to take a closer look at this contact me at support@xlinesoft.com providing the URL where I can see this.

P
phpwalker author 6/11/2007

Now it searches ultra-fast again...
one Question though: Will the new in-line editing feature (in your next version) require AJAX to be turned on?
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=18770&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />

Sergey Kornilov admin 6/11/2007

Yes.