How should I store my Data?
-
Hi! I´m trying to write some kind of media-management-software, where i have the name of the media and some other information to be stored in some kind of variable/database/etc... What i want to do is to offer some kind of full-text-search, which provied searching over some (not all) fields of my information-set. It also should work quite fast and with regular expression, somkind like the search-function in iTunes oder MSHelp/Index, so that as soon as i start typing the RegExp the results matching to that pattern are displayed in a result-window. I don´t care, in which way the data is stored permanently on my HD, because i would load the data on program-start into a C#-Datafield. But which one should i use to make this work? Who could recommend me a method to do this? Thanks J.Holzer
-
Hi! I´m trying to write some kind of media-management-software, where i have the name of the media and some other information to be stored in some kind of variable/database/etc... What i want to do is to offer some kind of full-text-search, which provied searching over some (not all) fields of my information-set. It also should work quite fast and with regular expression, somkind like the search-function in iTunes oder MSHelp/Index, so that as soon as i start typing the RegExp the results matching to that pattern are displayed in a result-window. I don´t care, in which way the data is stored permanently on my HD, because i would load the data on program-start into a C#-Datafield. But which one should i use to make this work? Who could recommend me a method to do this? Thanks J.Holzer
I think you can use lightweight database like mysql. Its very fast. Check this out. Live Life King Size Alomgir Miah
-
Hi! I´m trying to write some kind of media-management-software, where i have the name of the media and some other information to be stored in some kind of variable/database/etc... What i want to do is to offer some kind of full-text-search, which provied searching over some (not all) fields of my information-set. It also should work quite fast and with regular expression, somkind like the search-function in iTunes oder MSHelp/Index, so that as soon as i start typing the RegExp the results matching to that pattern are displayed in a result-window. I don´t care, in which way the data is stored permanently on my HD, because i would load the data on program-start into a C#-Datafield. But which one should i use to make this work? Who could recommend me a method to do this? Thanks J.Holzer
Hello... In my opinion to find the best method for this problem, you must resolve yourself some problems... How much data you will be store (1000 or 100000 strings) ??? Do you need a permant data access or only sometimes ??? The main problem when you use mySQL is that your Application is absolutly addicated to them and you need licenses for commercial use. I believe the best choice to store the data is xml when you not store 100000 of strings... It's well structered, easy to parse, independent from any other libraries and completly implemented in the net framework...
-
Hi! I´m trying to write some kind of media-management-software, where i have the name of the media and some other information to be stored in some kind of variable/database/etc... What i want to do is to offer some kind of full-text-search, which provied searching over some (not all) fields of my information-set. It also should work quite fast and with regular expression, somkind like the search-function in iTunes oder MSHelp/Index, so that as soon as i start typing the RegExp the results matching to that pattern are displayed in a result-window. I don´t care, in which way the data is stored permanently on my HD, because i would load the data on program-start into a C#-Datafield. But which one should i use to make this work? Who could recommend me a method to do this? Thanks J.Holzer
That depends on so many things... Desktop/Web app? How much data? How many simultaneous users you expect? Do you expect significant grow of amount of data and users? IMHO it is like XML < Access < MySQL < MSDE* < SQLServer. (ordered by amount of data/users) Some time ago I answered question about Access/MSDE, search the forum, there is link to MSDN page about different scenarios for Access/MSDE/SQL Server. *I put MSDE > mySQL because of easy upgrade to SQL Server :) Never forget: "Stay kul and happy" (I.A.)
David's thoughts / dnhsoftware.org / MyHTMLTidy -
That depends on so many things... Desktop/Web app? How much data? How many simultaneous users you expect? Do you expect significant grow of amount of data and users? IMHO it is like XML < Access < MySQL < MSDE* < SQLServer. (ordered by amount of data/users) Some time ago I answered question about Access/MSDE, search the forum, there is link to MSDN page about different scenarios for Access/MSDE/SQL Server. *I put MSDE > mySQL because of easy upgrade to SQL Server :) Never forget: "Stay kul and happy" (I.A.)
David's thoughts / dnhsoftware.org / MyHTMLTidyI plan a Desktop-App, that should work on it´s own without any external software. So all data-access-routines should be in my software/.net-framework. I wonder if an sql-query is that fast. The results should be seen instantly, while typing the pattern i´m searching for...