Flat file system
-
Hi, For my multiuser vb.net application i DONT want to use any commercial DBMS. How do i use flat file system for a multiuser application. Regards
Very painfully - it's called Access. You can use your own files too, but... I abhore using Access, or any other file-based database, for any multiuser system, but some other people have a different opinion. It can be done, but performance stinks, severly limiting scalability. If your system has an unknown upper limit on the number of users, save yourself the trouble and go with the DMBS up front. You won't have to convert your Access "SQL" to Real "SQL" code later. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
Hi, For my multiuser vb.net application i DONT want to use any commercial DBMS. How do i use flat file system for a multiuser application. Regards
MSDE is free, although it doesn't scale as well as SQL Server 2000. But Dave is right, do it properly, or don't do it at all. Christian Graus - Microsoft MVP - C++
-
Hi, For my multiuser vb.net application i DONT want to use any commercial DBMS. How do i use flat file system for a multiuser application. Regards
Google for Sqlite. Its completely filebased, only some kilobytes in size and faster than Access. It has its issues but it can work very well (there is even a native .Net provider for it).
-
Hi, For my multiuser vb.net application i DONT want to use any commercial DBMS. How do i use flat file system for a multiuser application. Regards