hey guys, Our company use Asterisk and MS SQL for an IVR application. Our application is based heavly on MS SQL. But we want to change to a linux server with Asterisk+RAGI (rails AGI)and a database but I dont know whether mySQL or postgreSQL is better for performance for rails? Are there any tests done to compate rails+mysql and rails+postgresql ? Thanks --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
maul wrote:> Are there any tests done to compate rails+mysql and rails+postgresql ?Performance is more determined by what you are doing. The difference is speed is probably negligible compared to doing optimizations in your own app as both are used in high-availability/high-performance sites. Use what makes sense for you development environment. Either will performance nicely. Eric --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Oct 4, 1:28 pm, maul <ekim.must...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> hey guys, > > Our company use Asterisk and MS SQL for an IVR application. Our > application is based heavly on MS SQL. But we want to change to a > linux server with Asterisk+RAGI (rails AGI)and a database but I dont > know whether mySQL or postgreSQL is better for performance for rails? > > Are there any tests done to compate rails+mysql and rails+postgresql ? > > ThanksYes, there are quite a few, not too hard to search for. you didn''t say anything about requirements, if you''re running exclusively in AR, or doing a little connection.execute(), or using smarter DBMS, PSQL, triggers, procedures, etc. http://groups.google.com/group/rubyonrails-talk/browse_frm/thread/afb9c86050bb23e6/ http://tweakers.net/reviews/657/6 --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
maul wrote: [...]> I dont > know whether mySQL or postgreSQL is better for performance for rails? > > Are there any tests done to compate rails+mysql and rails+postgresql ?Take a look at features, too. If you''re trying to store geographic data or use any stored procedures beyond the most rudimentary, PostgreSQL is definitely the way to go. Best, -- Marnen Laibow-Koser marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---