Click here to Skip to main content
15,918,193 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hey and thx in advance, i need some recommendations regarding a data container for my program hope you can help?

My program are taking in multiple data entries from many users and changing the data in relations to each users preferences, files data typically contain 100 lines which needs to be altered in regards to that user!

My question is which data container would be fastest, I am thinking about using and SQL database as this will be easy to maintain later on, but is it fast enough? program and database will be in the same system!
Posted

1 solution

User preferences are best kept in the applications settings file. To create the settings, right click the project in Project Explorer, choose properties in the context menu that shows up, then go to the Settings tab in the properties editor. There you can create as many settings as required and set them as either User or Application settings. To access these settings from your application, you just use something like this Properties.Settings.Default.yourSettingName.

Hope this helps
 
Share this answer
 
Comments
RaviRanjanKr 20-Oct-11 2:36am    
Comment by allanmoller :-
Thx for fast reply! good idea but aren't settings files somewhat limited in scale? for example if I where to add users/preferences wouldn't this be easier with SQL?

maybe I could do both, if I for example would use SQL, and when the data is needed I would load in entire table with data (100+ entries) and store in array as long as it is needed, and if not used for a couple of minutes remove array? would that be a good idea?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900