Greg Donald wrote: > Yes. At some point, as your traffic/requests increase, your sqlite db > will start to experience file lock errors. When depends on your code > and your hardware.
This is just my opinion, but I don't consider SQLite to be a production level database solution. That said I do use SQLite to begin most of my Rails projects, because it's just so convenient to work with. Later on when the application starts to get large, or I find tests taking too long, then I would probably switch to another database solution. But, I would probably never choose to run my application in production under SQLite. I just don't really see the point when nearly all deployment environment are going to be running MySQL or PostgreSQL anyway. As for MySQL vs Database X. I do have some opinions that I've gained though my own experiences. It is my impression that "out-of-the-box" MySQL has horrible INSERT/UPDATE performance compared to other database solutions. As a disclaimer, "I am not an expert DBA and maybe tuning would help." Unfortunately, I don't have experience comparing MySQL with PostgreSQL, But, on one project me and a partner decided MySQL wasn't cutting it for our needs so we switched to OpenBase and (again out-of-the-box) were able to handle over 5x the number of inserts/updates per second on a ~= 250GB database. I fully understand that other people's experience may vary, but from my perspective switching to OpenBase solved a problem that MySQL just wasn't able to handle. I'm not promoting OpenBase, and I've only used it in production for this one special case. I use MySQL for most of my applications and it typically works great. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
