![]() ![]() Instead, I used my Bingle-Fu to find a project called “ User options in XML” on CodeProject, by Richard Schneider. I used the suggestions provided by the accepted answer, but was not completely satisfied with the result, which worked on a per-user level. At least with the embedded database, the file was distributed with the application, but in the case of XML configuration, I’d need to be able to freely create and modify the settings file at will.Įnter, with a question that pointed me in the right direction. As mentioned above, this comes with specific rules about where you can save your files. I readily admit that the connection speed is probably my fault, but when it comes right down to it, I used the Windows Registry because I only need to save around ten plain-text values, and it felt as though I was over-engineering things.Īfter announcing on Twitter that SQL CE was too slow, I decided to fall back to my original XML idea. Since the new ShutOff 2000 has a command-line interface, I wanted millisecond response times from the stored settings. The queries themselves to store and retrieve records were fast, but the initial connection was too slow. Unfortunately, in all of my testing, SQLite and SQL CE was just not fast enough. Originally, I used SQLite, but after playing around with it for a while, I decided that there was a lot of overhead attached to this, as well as non-native interops, so I switched instead to use SQL Compact Edition (SQL CE), which operates in a similar fashion to SQLite. I toyed around with encrypting the file, making it binary, and so on, but eventually I dismissed the notion and decided to use an embedded database. Right from the start, I wanted to store everything in an XML file. However, Microsoft’s best practice for the Windows 7 and Windows Server 2008 R2 platform does not allow for this, so I’ve been researching new ways to store settings outside of the Registry. The Visual Basic 6 edition of the application has always used the Windows Registry to store its settings. The product is fast approaching code completion. ![]() A new beta of ShutOff 2000 v3.0.0 is now available. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |