On 1/13/11 10:11 AM, Ed Leafe wrote: > On Jan 13, 2011, at 1:05 PM, Paul McNett wrote: > >> Oh, and just a sidenote: while we don't officially support it, I know of a >> handful of >> these users that have networked their sqlite database. Multiple workstations >> on their >> network successfully read/write to the single shared sqlite database. There >> haven't >> been any issues with this, which does surprise me a little. I'd imagine >> there will be >> scaling problems if they try to get dozens of computers connected to the same >> database at the same time though. > > > The networking/scaling possibilities/limitations of sqlite are no > different than for VFP using DBFs. Before I learned how to use VFP with > database servers, I created several large networked multi-user apps that > worked just fine. The highest concurrent usage was 400 users.
True. I guess I was thinking that the transactional capabilities could cause some conflicts, since they would be handled on each client individually since there's no central server. But it seems to work just fine. I still have an app in the field that uses DBF's on a network share, it it works just fine too, and uses transactions, so I'm not sure in retrospect exactly why I was surprised WRT sqlite! Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
