Winform App crashed when loading bulk of data from SQL EXPRESS

[handokowijaya]

Hi,

I'm having some problem loading data from SQL Express with my winform app. It crashed (waiting indefinitely) when loads the actual data that contains thousands of records. So i tested the app using only hundreds of records and everything works fine. The reason i'm loading all the data at once is because i'm using the standard form (binding navigator) that displays all the data and allow user to navigate each record.

Does anybody had this problem before? Can somebody help me with a solution?

Thanks
han

 

[lingsn]

May be can check the SQL that you are using. Sometimes the SQL will take more time if got many join.

 

[cjard]

Databases are for data, user controls are not for storing 50,000 records in and expecting the user to scroll through them. Suppose your table one days grows to 3 gig, are you going to have the user wait 4 minutes to transfer all that data over the network, into the control which causes your app to consume more than 3 gigs of memory, which causes your page file to fill up.. and I think you get the idea.

Perhaps redesigning this aspect of your program would be an appropriate course of action..