It entirely depends on your query. If you are just finding by ID, then
it''s
likely to be in the 7 figure range (10,000,000+).
If you''re doing complex joins and searches within strings, then
you''d need
to test it.
The short answer is test it! It''s easy enough in script/console to
quickly
insert a million rows, then actually test/benchmark your app.
Cheers,
Andy
--
Andy Jeffries
http://andyjeffries.co.uk/ #rubyonrails #mysql #jquery
Registered address: 64 Sish Lane, Stevenage, Herts, SG1 3LS
Company number: 5452840
On 29 April 2010 09:13, TechSlam
<aslam9895-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> Hi
>
> I have a Student table with 30 columns in it.
>
> My question is at what database size, would the query performance be
> affected?
>
> We are actually planning to have a ArchivedStudent table(which has
> exactly the same structure as that of Student table) so that when
> student graduates, his record can be moved out of active Student table
> to ArchivedStudent table. or should I just go for named scopes?
>
> --
> 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org>
> .
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.
>
>
--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.