For a production site I suggest using postgresql. I have seen very bad failures of sqlite when for example you run out of disk space. Complete database corruption.
On Mar 9, 3:47 am, Joe Barnhart <[email protected]> wrote: > I managed to get the site limping along again by deleting some indexes > I created on the tables that map many-to-many relationships. Why > these indexes should dramatically slow Sqlite down I do not know... > > On Mar 9, 1:40 am, Joe Barnhart <[email protected]> wrote: > > > Well, my site went down hard tonight. It is based on a lot of linked > > tables and tonight I started getting the dreaded "database is locked" > > error. This error occurs only on operations that might require > > several seconds of DB time. I suspect lengthening a timeout value > > somewhere would alleviate it, but I'll be damned if I can find out > > where to set it. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
