Arfon - you might check this out:
archives.postgresql.org/pgsql-sql/2002-04/msg00318.php
It''s somewhat dated and deals with postgresql but
" We currently have about 100GB of data and will soon grow to a multi-
terabyte system. We have tables of up to 1 billion rows and have been
able to get ~1 million row queries to run in about 5 min. "
Rick
On Nov 27, 5:15 am, Arfon Smith
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> I''m looking at building a Rails application which will have some
pretty
> large tables with upwards of 500 million rows. To keep things snappy
> I''m currently looking into how a large table can be split to more
> manageable chunks. I see that as of MySQL 5.1 there is a partitioning
> option and that''s a possible option but I don''t like the
way the column
> that determines the partitioning has to be part of the primary key on
> the table.
>
> What I''d really like to do is split the table that a AR model
writes to
> based upon the values written but as far as I am aware there is no way
> to do this - does anyone have any suggestions as to how I might
> implement this or any alternative strategies?
>
> Thanks
>
> Arfon
> --
> Posted viahttp://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@googlegroups.com
For more options, visit this group at
groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---