Any database performance test for rails?

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

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

On Oct 4, 1:28 pm, maul [email protected] 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 ?

Thanks

Yes, 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

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
[email protected]

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs