For this specific task (storing ID and material relations) I think it will be very read-heavy. But from what you said it probably will not scale well if I expand it to cover other area... hmm
Thanks again Justin :) On Saturday, September 7, 2013 8:19:37 AM UTC+7, Justin Israel wrote: > Is your application write heavy? If so, sqlite may be a significant > performance decrease over postgres, because of the database locking during > concurrent write access or a write happening in combination with readers. > > > On Sep 7, 2013 12:48 PM, "Panupat Chongstitwattana" <[email protected]> wrote: > > > > > > > Hi everyone. > > I've been thinking about switching database of my pipeline tools from > PostgreSQL to SQLite but still uncertain how reliable it is? > > The reason is that we're having a co-production going on between a few studio > and to get PostgreSQL working on their end has not been easy... Most studio > in my country do not hire IT so there's no one to set up the database nor > install the necessary modules on client machines. > > > > > I expect the maximum database users to be 60-70 at most. > > > Thanks. > > ~Panupat. > > > > > > -- > > You received this message because you are subscribed to the Google Groups > "Python Programming for Autodesk Maya" group. > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > > To post to this group, send email to [email protected]. > > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Python Programming for Autodesk Maya" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
