Search In Browse

[JLCUENCA]

Anybody knows how works the search in a browser when press any key.

My problem is that I have a browser in a table with a few thousand records and when somebody press a letter or any key the internal search is very slow even the users think that the machine goes down.


Thanks

 

[mra]

If you use column search in browse widgets, the entire search is done on the client machine. This means, that every row has to be fetched to the client to be compared. You can actually see the process in the scroll bar.

If you want better control, you could catch the START-SEARCH event on the browse, and then reopen the query with the new result set.

If the result set is large (more than 20-50 rows), I prefer to give the user some input fields to enter their search parameters in. The browse can then be reopened by pressing a button.


Regards
Mike