-
Jul 24th, 2010, 05:38 AM
#1
Thread Starter
Fanatic Member
[RESOLVED] Design question.
I'll try to give you a short explanation of my problem; if you need more information, please feel free to ask here, and I'll provide it asap.
I'm basically implementing a user-interface on a database, that will allow the user to interact with the database without actually having access to it. There are 4 major tables of information:
* Persons (containing basic information about Persons - BIG)
* Clubs (containing basic information about Clubs - SMALL)
* Members (joining Persons and Clubs to keep track of memberships - BIG)
* Logins (keeping track of Member visits to Clubs - ENORMOUS)
Usually when implementing such systems, I'll make a main window with a tab-strip for each part (table in this case) of the data. Each tab-strip will contain a list of commands available on the data and a readonly datagrid for displaying searchresults and allowing for selections to be edited/deleted through pop-up windows. My concern is though, that several datagrids containing huge amounts of information, will take it's toll on the system ressources, and perhaps my approach should be different in this case. I'd like inputs as to how you usually implement such systems.
Further info:
* Persons - approximately 120 bytes information each ~ 10,000 entries
* Clubs - approximately 40 bytes information each ~ 25 entries
* Members - approximately 20 bytes information each ~ 3,000 entries
* Logins - approximately 30 bytes information each ~ 200,000+ entries
All tables are indexed on one or more fields to allow for fast searching.
The Login table will never be used in it's entirity but the other tables may.
Any/all inputs appreciated - even if you never implemented anything similar.
[The core of the question is probably whether a datagrid will load assigned query-data in it's entirity or retrieve it on an 'as-needed' basis.]
Regards Tom
-
Jul 24th, 2010, 06:05 AM
#2
Re: Design question.
I'm not sure how the framework's DataGridView performs with such large number of items, but the only grid I've ever used (a third party grid from Infragistics) does it just fine. I've seen it handle up to 500.000 items simulatenously. Sorting, grouping, scrolling, filtering, all happens instantly. If this project is your own project then maybe getting a third party grid (it's not free) isn't an option, but if you are doing this for some company then you might want to consider it.
That said, if the framework's grid has the same performance (I honestly don't know) then it might not be worth it either. But this grid has some pretty great functionality, like I mentioned before sorting, filtering, grouping, multiple views, all out of the box without having to write a single line of code.
-
Jul 24th, 2010, 06:20 AM
#3
Thread Starter
Fanatic Member
Re: Design question.
Originally Posted by NickThissen
I'm not sure how the framework's DataGridView performs with such large number of items, but the only grid I've ever used (a third party grid from Infragistics) does it just fine. I've seen it handle up to 500.000 items simulatenously. Sorting, grouping, scrolling, filtering, all happens instantly. If this project is your own project then maybe getting a third party grid (it's not free) isn't an option, but if you are doing this for some company then you might want to consider it.
That said, if the framework's grid has the same performance (I honestly don't know) then it might not be worth it either. But this grid has some pretty great functionality, like I mentioned before sorting, filtering, grouping, multiple views, all out of the box without having to write a single line of code.
Thank you very much for the input. However getting any 3rd party software or even spending anything except time on this is out of the question, since I'm implementing it as a favor to my boss along with software for online login service and online database access (which is the essential part and already completed ). I don't even work as a programmer anymore (and haven't for many years) and atm I'm only doing freelance assignments (for free ).
Tom
-
Jul 24th, 2010, 09:39 AM
#4
Re: Design question.
SQL Server Management Studio is a .NET application, so it uses the DataGridView control itself. If you find performance becomes a problem because of large amounts of data, you can look into the virtualisation support built into the DataGridView.
-
Jul 24th, 2010, 09:41 AM
#5
Re: Design question.
Ah, I just noticed that you're using .NET 1.x, which supports the DataGrid but not the DataGridView. Is that a requirement, or could you upgrade to a more recent version of VS? The Express editions are free and would most likely provide everything you need.
-
Jul 24th, 2010, 11:18 AM
#6
Thread Starter
Fanatic Member
Last edited by ThomasJohnsen; Jul 24th, 2010 at 02:47 PM.
-
Jul 24th, 2010, 06:08 PM
#7
Re: Design question.
I think you misunderstood. You can get a free version of Visual Studio, either for VB.NET or for C#.NET (but not combined), and it's called either Visual Basic Express 2010 or Visual C# Express 2010.
Visual Studio is the non-free version and combines both VB and C# into a single IDE, along with some other more advanced features that the free Express versions don't have. But you most probably don't need any of those features.
So just download Visual Basic 2010 Express, for free, and you will be up to date.
-
Jul 25th, 2010, 01:28 AM
#8
Fanatic Member
Re: Design question.
I think Visual Basic Express is considered part of Visual Studio. At least I have Visual Studio folders on my computer and I have never purchased VB or VS.
-
Jul 25th, 2010, 03:02 AM
#9
Thread Starter
Fanatic Member
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|