<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - AutoFilter Search Freezes Calc if the column contains many unique values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122419#c17">Comment # 17</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - AutoFilter Search Freezes Calc if the column contains many unique values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122419">bug 122419</a> from <a class="email" href="mailto:suokunlong@126.com" title="Kevin Suo <suokunlong@126.com>"> Kevin Suo</a> <pre>My feeling is that there are 2 areas which makes this slow: 1. The search/sort logic may be slow and thus return the result with a delay. This can be seen if we type in one single char in the search box. 2. The type-and-see logic, without setting a wait time before the input is accepted as search string. For instance, if I want to search for records containing string "abc", I would type these three chars one by one, so if the program does not wait for (1s?), then it will try to search each time the key is pressed, which is of cause a waste of time and CPU. Another choice is to add a "OK" button and only start search if the button or ENTER is pressed.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>