Small business app.

[wyrd]

Whats a good number of items a program should be able to handle (items within a database that is) in a speedy, efficient manner.. 100 thousand, 500 thousand, 1 million, 5 million, a billion?

This would be for a small business application.

Oh, and paging.. whats a good way to handle paging (both in terms of program design and also via SQL statements)? I ran into a small program while testing my program and handling 100,000 items in a ListView seems to be a bit much. LOL Yes I know Im insane, I just havent added paging yet. Plus, I was curious as to how far I could go with the ListView before it started making my program slugish.

Also I have a question on some table design issues that Im boggling over. Ill post tomorrow when I get time, so please recheck this thread then. In the mean time Im curious about the above questions.

 

[ashrobo]

~3000 items in the listview makes my program sluggish and i almost fainted. it took ~1min to load all of them.. datagrid took a few secs with the same data.

perhaps i was being shallow in not knowing that datagrid is better than listview.. just wanted to try things out.

-ashrobo

 

[wyrd]

Yours got sluggish after displaying 3,000? Odd.

EDIT:
I just did a minor test, you are right that the DataGrid holds larger numbers easier. Interesting.

 

[ashrobo]

Originally posted by wyrd
Yours got sluggish after displaying 3,000? Odd.

not too sure if its because of my code, but there dont seem to be much pre-processing of data before displaying..