AutoComplete and Minimum Length

QuestionsAutoComplete and Minimum Length
DGea asked 4 years ago

Hello,

I just make sure that the best way to reduce the load of data when using AutoComplete is to turn MINLENGTH.
So, not only do a search based on the begin of the word, but also can do a search in the middle of a word

However, I've tried to do it (Edit lib/inc/jqgrid_dist.php, Change: "minLength":1, to: "minLength":3,) but do not function properly.

My Question:
1. Is the new version is not there a problem about MinLength?
2. Is the new version supports the latest JQuery?

1 Answers
Abu Ghufran answered 4 years ago

Hi,

1) MinLength should not ease the load of query. Mysql does not perform well with contains search. It only use indexes with begins with search. (like 'abc%'). I'm afraid this issue will exist as it is database performance isssue.

http://stackoverflow.com/questions/11418932/performance-of-like-queries-on-multmillion-row-tables-mysql

2) It uses jQuery v1.11.0

Your Answer

17 + 15 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!