Hi,

I've seen a lot of posts related to the subject and this limitation which Form-based has is affecting our business operation. There should be some ways to resolve this thing and/or some technical workarounds (without functional changes).

To add more context on my panicked tone, our users cannot accept any technical documentations that would help me explain to them that I cannot do anything when our application crashes each time they perform "big" searches unless they accept "pagination" and or limit their expected query results. Please add to the fact that the query is against millions of records and it is but annoying for any user to wait for considerable time only to seethe application crash.

Making things worse, our users are doctors and thedata they are trying to view may be life-saving information.

Again, pleaseallow me to mentionthat nofunctionalchange is acceptable - users badlyneed (for whatever purpose or reason they have)to view records that could reach 10k rows (presented in user controls) per query.I would greatly appreciate if anybody could give opinions and/or resolutions .

PLEASE HELP!!!!

Best Regards,

Dhon Nuevo

Hi Dhon Nuevo,

Based on my understanding, you want improve the performance of your application without changing your application, right? If so, I don’t think there is any technical workarounds to improve the performance when working with large amounts of data without changing your application. Using a more powerful computer would help. But I recommend you use a DataGridView with paging to avoid performance penalty when working with large amounts of data.

Here is some sample for your reference.
http://www.codeproject.com/KB/miscctrl/Pagable_DatagridView.aspx
http://www.codeproject.com/KB/miscctrl/Paging_DataGridView.aspx
http://www.codeproject.com/KB/cs/DataGridView_paging.aspx

Hope this helps.
Best regards.
Rong-Chun Zhang

Hi Dhon Nuevo,

Based on my understanding, you want improve the performance of your application without changing your application, right? If so, I don’t think there is any technical workarounds to improve the performance when working with large amounts of data without changing your application. Using a more powerful computer would help. But I recommend you use a DataGridView with paging to avoid performance penalty when working with large amounts of data.

Here is some sample for your reference.
http://www.codeproject.com/KB/miscctrl/Pagable_DatagridView.aspx
http://www.codeproject.com/KB/miscctrl/Paging_DataGridView.aspx
http://www.codeproject.com/KB/cs/DataGridView_paging.aspx

Hope this helps.
Best regards.
Rong-Chun Zhang

Hi Rong-Chung Zhang,

Thanks for your reply.

Luckily, we managed to find a technical solution for our users' (almost) unbelievable requirements. What we did is we placed a logic to a Scrollbar's in away that we shall dynamically create user controls only when needed based on scrollbar's position. On a separate thread, we are computing the heights of user controls and update the scrollbar properties.

The solution we came up with attended both our performance and crashing concerns (10k handles limitation of .net). I'd be glad to share the concepts we did for anybody who'd possibly need it.

Thanks.

Best Regards,

Dhon