On Fri, Nov 13, 2015 at 12:55 PM, A. Mannini <alessandro.mannini at esod.it> wrote: > > Ok, thanks for all your replies!!! > > First, i was asking to understand...before to start development in a > wrong direction. > > I don't have experience with SQLite and even less on a network share. I > would understand if corruption is a remote possibility or a certainty. > > Someone said that Access suffer the same problem... In my experience > even with 20-30 clients with low concurrency (management software) MS > Access file corruption is a rare event. > (the article you linked refer to a bug with an hotfix) > I can't use Access in my case because my application is x64. > > About VistaDB it support use on network share look at > http://www.gibraltarsoftware.com/Support/VistaDB/Documentation/WebFrame.html#VistaDB_Introduction_SupportedPlatforms.html > and confirmed from its support. Unfortunately i have not experiences > with it....i can't say how much this is true...
The quote from that page reads: "Multi-user applications that access data on a shared network drive". The problem is that not all multi-user applications are created equal. For example, maybe there is a multi-user application that accesses data on a shared network drive, but the multiple users work different shifts and there is never more than one person using it at a time. Or perhaps each user accesses a particular customer account, and each customer account is stored in a different database or directory. In many (perhaps most) cases, there won't be any problems. You might run these types of applications for months or years without ever seeing a problem. Until one day when a problem rears its ugly head. At that point you won't really care who is at fault: SQLite, MS Access, SMB or NFS network shares, a buggy file system, a buggy operating system, buggy firmware on the drive, misconfigured hardware or software, ... the list is practically endless. The reason that SQLite warns against using network shares is because they have been a repeated source of problems. Many people use them successfully, but when they break, they break hard. Asking "which network file system is best for my data integrity" might be likened to asking "which brand of cigarettes are best for my health". You can probably answer them in some way, but the real answer is "none" in both cases. -- Scott Robison
