On Jun 1, 3:34 am, Marnen Laibow-Koser <rails-mailing-l...@andreas- s.net> wrote: > > Is there any built-in way to handle this in rails (or a popular plugin > > that can do this)? > > I think you will want to do this on the DB side rather than in the app. > The various DB servers out there have ways of breaking up tables for > performance reasons and still having them look the same to the > application (I think MERGE tables in mySQL fit this description). So > investigate what your DB server can do for you before you start trying > to get clever with table-based subclasses. > Although completely splitting up tables (ie sharding) is a well known technique when having a single database server becomes a bottleneck. Depending on the balance of reads and writes in your application, there can be gains to be had by doing your writes to the master server and doing reads from one (or more) slave servers that replicate the master. There is a plugin (masochism) that used to handle some of this, I haven't looked at it in a while though.
Fred --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
