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

Reply via email to