Hi Fabio. Thanks for your reply (my honour). > Only a comment here...between the "type three" and double-click there is > nothing that mean you: > upload all customers and filter in ram for the first three chars during > users typing > > I hope your system is very little (max 500 customers).
While typing the first three characters and clicking on the right username, ok, there is a query execution. The query should retrieve only the first N customers matching the filter, where N might be equal to the double of the rows currently visible in the DataGridView. If the user clicks on the scroll bar to go down through the list (rather than narrowing the search with more characters), on necessity, a similar query should pick the following records (e.g. N more records). If the user narrows the search, the search form should be possibly smart enough to avoid to fire one more query, and perform an in memory filtering on the already available records. Furthermore, another performance improvement, while the user types his three characters, a little "inactivity-delay" might be set before firing the search (e.g. 400ms). If the user is fast enough (as he should be since, ehm..., this is one of the most common use cases), the query should be fired only when the search filter has been completed, so avoiding to fire unnecessary queries. Ok. Though I see this kind of smart search form not impossible to be coded, maybe there are some technical obstacles I don't see here. Maybe SetMaxResults() is not portable onto all DBMSs and sometimes performs just an in-memory-filtering after having downloaded the entire world. But, in this case, I can't figure out how do you let your users easily choose the right invoice customer starting from the customer name. Thank you. Marcello. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
