Re: [Rails] Storing some data to a different DB

On 26 November 2012 08:03, comopasta Gr <lists@ruby-forum.com> wrote:
> I'm working on an Business Intelligence application where customers will
> be adding values about different indicators. For example "Blue cars sold
> daily", then every day a record is stored representing that indicator.
>
> So there can be many indicators and many many more values for each
> indicator.
>
> Right now everything is living in the same DB. Since the amount of
> values can be huge after some time I'm now wondering if the values
> should be stored in a different DB somehow.

What do you mean by huge?

>
> I imagine the auto-increment IDs might someday restart and cause a nasty
> issue if IDs that are used for the associations of the other objects get
> overwritten.

That depends on what you mean by huge.

>
> Should I be worried about this and move the values storage to a separate
> space? Any good suggestions?

Again it depends on what you mean by huge.

Colin

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.