> Speed in which direction is your priority? SELECTS, INSERTS? Both? > > MySQL is fast out of the box... but it has been my experience that in > larger databases (hundreds of GB to TB...) PostgreSQL wins hands down. > > SQLite is nice for a small application with a small database.
Up to what extent is sqlite suitable for an online application? Above what DB size and req/s does sqlite start to lose ground against psql/mysql? Has anyone had to migrate a live app from sqlite to psql/mysql/etc due to performance reasons? Best regards, -- 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 -~----------~----~----~----~------~----~------~--~---
