Hi Nelson, If you only plan to ever have one user using Review Board, SQLite is fine. Beyond that, it doesn't scale. It's not meant to be a big database used by tens or hundreds or thousands of users. The way it handles locking, one write can lock the database and block everyone who wants to read. Every deployment we've seen that used SQLite has at one point realized the limitations and wanted to convert to something else, and that can be difficult. So, unless this is just a throw-away test deployment, I'd advise not bothering with SQLite.
Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com On Wed, Oct 19, 2011 at 7:59 PM, Nelson Jones <huawen....@gmail.com> wrote: > Your documentation says "While useful and portable, SQLite does not > handle large loads with many concurrent users very well. We strongly > recommend using MySQL or PostgreSQL for a real deployment." > So does it mean that MySQL is a winner over SQLite for scalabilty and > stalability? Is there a boundary say X TeraBytes? Or X PteraBytes? > Any infomation or detail would be helpful. Thanks. > > -- > Want to help the Review Board project? Donate today at > http://www.reviewboard.org/donate/ > Happy user? Let us know at http://www.reviewboard.org/users/ > -~----------~----~----~----~------~----~------~--~--- > To unsubscribe from this group, send email to > reviewboard+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~----------~----~----~----~------~----~------~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en