On 11/23/10 8:41 PM, "Jonathan Lynch" <jonathandly...@gmail.com> wrote:
> I am in the same sort of boat. > > I am making an application that would use a database file on a shared drive. > Maybe 10-20 people would be writing to it during any given day. It seems > like Valentina would be a good choice for this, but, as silly as it sounds, > I don't have a practical funding mechanism to pay for the $200 expense. > > I might try doing it with SQLite, but this conversation, and a few previous > conversations related to this topic, are making me nervous about doing that. * From 1998 to 2002(3) year ... While Valentina engine was single user only and was no Valentina Server, Valentina users did use OPEN/CLOSE trick I think you can use the same trick now for both A) SqlLite B) Valentina in single user mode For their dbs that are on shared volume. I remember that yet in 1999-00, on that time hardware, Was a German user, which told he is able manage in this way group in 50-100 users. On modern hardware limits can be higher I think. ----- And keep in mind that this open/close trick, of course kills idea of DB Cache. Another Valentina user did bench, and told us that for him, Valentina Server way works near to 17-20 times faster of open/close trick. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
