Re: Table Row count: Limiting factor

2008-07-22 Thread madhav

Thanks Malcolm and my apologies for posting it here.

On Jul 21, 11:49 pm, Malcolm Tredinnick <[EMAIL PROTECTED]>
wrote:
> On Mon, 2008-07-21 at 08:13 -0700,madhavwrote:
> > Hello guys, I am just confused with a fundamental db problem. I have
> > table which has got 48 lakh rows(each row has got 8 fields, all
> > INDEXED) and I just need to fetch 500 rows from it. Would that take
> > more time than extracting the same number(500) of rows from a small
> > table of say 1 Lakh rows? Each row field is indexed in both the cases.
> > Please correct me if I am wrong.
>
> This sort of question is more appropriate for django-users than here.
> It's also something you should test for yourself on your real data. The
> best way to work out a performance question is to time it.
>
> Malcolm
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-developers?hl=en
-~--~~~~--~~--~--~---



Re: Table Row count: Limiting factor

2008-07-21 Thread Malcolm Tredinnick


On Mon, 2008-07-21 at 08:13 -0700, madhav wrote:
> Hello guys, I am just confused with a fundamental db problem. I have
> table which has got 48 lakh rows(each row has got 8 fields, all
> INDEXED) and I just need to fetch 500 rows from it. Would that take
> more time than extracting the same number(500) of rows from a small
> table of say 1 Lakh rows? Each row field is indexed in both the cases.
> Please correct me if I am wrong.

This sort of question is more appropriate for django-users than here.
It's also something you should test for yourself on your real data. The
best way to work out a performance question is to time it.

Malcolm



--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-developers?hl=en
-~--~~~~--~~--~--~---