Re: How would Django handle a large number of records

2006-06-21 Thread Adrian Holovaty

On 6/21/06, Patrick J. Anderson <[EMAIL PROTECTED]> wrote:
> There are a few small admin interface issues I'd still need to work
> out, mainly I might have a similar number of records related to
> articles (the number of article assignments might be slighltly smaller
> to the number of articles, lets say 20,000), so I'd like to limit
> foreign key form elements to something user-friendly. Not sure yet how
> to do it, but I'm sure I'll find a way.

For that, you could use either the "limit_choices_to" or
"raw_id_admin" field options.

Adrian

-- 
Adrian Holovaty
holovaty.com | djangoproject.com

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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-users
-~--~~~~--~~--~--~---



Re: How would Django handle a large number of records

2006-06-21 Thread Patrick J. Anderson

Thanks, guys! That's what I thought, but it helps to have a
conformation, Wilson:). Great job on Django!

There are a few small admin interface issues I'd still need to work
out, mainly I might have a similar number of records related to
articles (the number of article assignments might be slighltly smaller
to the number of articles, lets say 20,000), so I'd like to limit
foreign key form elements to something user-friendly. Not sure yet how
to do it, but I'm sure I'll find a way.

Wilson Miner wrote:
> > The World Online admin
> > interface (where Django was born) has a number of content types with
> > tens of thousands -- if not hundreds of thousands -- of records.
>
> 393,181 stories and counting...
>
> On 6/21/06, Adrian Holovaty <[EMAIL PROTECTED]> wrote:
> >
> > On 6/21/06, Patrick Anderson <[EMAIL PROTECTED]> wrote:
> > > We have about 80,000 records which we will need to migrate. I'm wondering
> > > how Django admin interface would deal with such amount of data (they
> > > are of the same type, so they might be managed by a single app). I know
> > > Django comes from the news publishing world, where databases are huge,
> > > but this is a key question for us, and would like to hear comments that
> > > will put my concerns to rest, so we can start coding (well, we already
> > > have the models and the admin interface:)). Any tips would be appreciated,
> > > too.
> >
> > Hey Patrick,
> >
> > The admin interface really doesn't care about how many records you
> > have; the user interface is built to scale. I wouldn't expect to have
> > any problems with the admin interface. The World Online admin
> > interface (where Django was born) has a number of content types with
> > tens of thousands -- if not hundreds of thousands -- of records.
> > Pagination, filters and searches on the changelist are quite useful in
> > those cases! :)
> >
> > Generally when dealing with lots of records, the pressure point is the
> > database. Make sure your database is optimized for the data you have.
> >
> > Adrian
> >
> > --
> > Adrian Holovaty
> > holovaty.com | djangoproject.com
> >
> > >
> >


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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-users
-~--~~~~--~~--~--~---



Re: How would Django handle a large number of records

2006-06-21 Thread Wilson Miner

> The World Online admin
> interface (where Django was born) has a number of content types with
> tens of thousands -- if not hundreds of thousands -- of records.

393,181 stories and counting...

On 6/21/06, Adrian Holovaty <[EMAIL PROTECTED]> wrote:
>
> On 6/21/06, Patrick Anderson <[EMAIL PROTECTED]> wrote:
> > We have about 80,000 records which we will need to migrate. I'm wondering
> > how Django admin interface would deal with such amount of data (they
> > are of the same type, so they might be managed by a single app). I know
> > Django comes from the news publishing world, where databases are huge,
> > but this is a key question for us, and would like to hear comments that
> > will put my concerns to rest, so we can start coding (well, we already
> > have the models and the admin interface:)). Any tips would be appreciated,
> > too.
>
> Hey Patrick,
>
> The admin interface really doesn't care about how many records you
> have; the user interface is built to scale. I wouldn't expect to have
> any problems with the admin interface. The World Online admin
> interface (where Django was born) has a number of content types with
> tens of thousands -- if not hundreds of thousands -- of records.
> Pagination, filters and searches on the changelist are quite useful in
> those cases! :)
>
> Generally when dealing with lots of records, the pressure point is the
> database. Make sure your database is optimized for the data you have.
>
> Adrian
>
> --
> Adrian Holovaty
> holovaty.com | djangoproject.com
>
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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-users
-~--~~~~--~~--~--~---



Re: How would Django handle a large number of records

2006-06-21 Thread Adrian Holovaty

On 6/21/06, Patrick Anderson <[EMAIL PROTECTED]> wrote:
> We have about 80,000 records which we will need to migrate. I'm wondering
> how Django admin interface would deal with such amount of data (they
> are of the same type, so they might be managed by a single app). I know
> Django comes from the news publishing world, where databases are huge,
> but this is a key question for us, and would like to hear comments that
> will put my concerns to rest, so we can start coding (well, we already
> have the models and the admin interface:)). Any tips would be appreciated,
> too.

Hey Patrick,

The admin interface really doesn't care about how many records you
have; the user interface is built to scale. I wouldn't expect to have
any problems with the admin interface. The World Online admin
interface (where Django was born) has a number of content types with
tens of thousands -- if not hundreds of thousands -- of records.
Pagination, filters and searches on the changelist are quite useful in
those cases! :)

Generally when dealing with lots of records, the pressure point is the
database. Make sure your database is optimized for the data you have.

Adrian

-- 
Adrian Holovaty
holovaty.com | djangoproject.com

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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-users
-~--~~~~--~~--~--~---



How would Django handle a large number of records

2006-06-21 Thread Patrick Anderson

Hi!

I'm impressed with Django and all the fuss that it removed from my
development. Our organisation is considering moving our document
management from an old Access db to PostgreSQL and I thought of using
django as an admin interface, plus public interface (sometime down the
line.)

We have about 80,000 records which we will need to migrate. I'm wondering
how Django admin interface would deal with such amount of data (they
are of the same type, so they might be managed by a single app). I know
Django comes from the news publishing world, where databases are huge,
but this is a key question for us, and would like to hear comments that
will put my concerns to rest, so we can start coding (well, we already
have the models and the admin interface:)). Any tips would be appreciated,
too. 


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@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-users
-~--~~~~--~~--~--~---