Diego Bernardes wrote: > Hi, > > I got a application actualy running on mysql, but, due a contract with a > client, the application can get some complex queries and lots of users > (like 10x more users). > > Its a academic application, and the company we are negociating have 7k+ > students. > > Im worry about the database, its better stick with de mysql? migrate to > postgresql? > > Which one can scale better with quality?
PostgreSQL is my default choice for all projects. It's a better database overall than mySQL, and does not force you to choose between data integrity and speed the way mySQL does. I'm told it doesn't handle clustering quite as well as mySQL, but that's its only real disadvantage. However, it is likely that either database will scale suitably. The more immediate problems are likely to come from inefficient queries. > > Thanks! Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- 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 -~----------~----~----~----~------~----~------~--~---
