Re: Massive insertion of records

2011-01-07 Thread Thomas Weholt
On Fri, Jan 7, 2011 at 2:31 PM, Derek wrote: > Thomas > That looks potentially useful - can you please give an example (on the > webpage) of how to do a multi-row insertion?  I typically need to add > thousands of rows from existing spreadsheets - am using xlrd to read the >

Re: Massive insertion of records

2011-01-07 Thread Derek
when > >> you're writing management commands. > >> > >> - Craig - > >> > >> On Mon, Dec 27, 2010 at 05:29, derek <gamesb...@gmail.com> wrote: > >>> > >>> Can you explain what you mean by "manual commitments" (prefer

Re: Massive insertion of records

2011-01-06 Thread Thomas Weholt
dasi...@yahoo.com> wrote: >>> > OK. I found a "solution". >>> > Using manual commitments after lots of insertions (ex. >1000) makes the >>> > massive insertion very fast (at least for my needs). >>> > >>> > Thanks to

Re: Massive insertion of records

2010-12-29 Thread Derek
a code example)? >> >> Thanks >> Derek >> >> On Dec 26, 4:38 am, Silva Paulo <psdasi...@yahoo.com> wrote: >> > OK. I found a "solution". >> > Using manual commitments after lots of insertions (ex. >1000) makes the >> massive

Re: Massive insertion of records

2010-12-27 Thread W. Craig Trader
action.commit() > > > > > > --- On Mon, 12/27/10, derek <gamesb...@gmail.com> wrote: > > > From: derek <gamesb...@gmail.com> > > Subject: Re: Massive insertion of records > > To: "Django users" <django-users@googlegroups.com>

Re: Massive insertion of records

2010-12-27 Thread Silva Paulo
t; From: derek <gamesb...@gmail.com> > Subject: Re: Massive insertion of records > To: "Django users" <django-users@googlegroups.com> > Date: Monday, December 27, 2010, 11:29 AM > Can you explain what you mean by > "manual commitments" (preferably with > a

Re: Massive insertion of records

2010-12-27 Thread W. Craig Trader
t; --- On Fri, 12/24/10, Silva Paulo <psdasi...@yahoo.com> wrote: > > > > > > > > > > > > > > > > > From: Silva Paulo <psdasi...@yahoo.com> > > > Subject: Massive insertion of records > > > To: "newbie" <django-us

Re: Massive insertion of records

2010-12-27 Thread derek
the > massive insertion very fast (at least for my needs). > > Thanks to all who answered. > > --- On Fri, 12/24/10, Silva Paulo <psdasi...@yahoo.com> wrote: > > > > > > > > > From: Silva Paulo <psdasi...@yahoo.com> > > Subject: Massive i

Re: Massive insertion of records

2010-12-25 Thread Silva Paulo
o <psdasi...@yahoo.com> > Subject: Massive insertion of records > To: "newbie" <django-users@googlegroups.com> > Date: Friday, December 24, 2010, 6:26 PM > I need to do a massive insertion of > records in two tables "connectd" by "foreignkey". Is th

Re: Massive insertion of records

2010-12-25 Thread Christophe Pettus
On Dec 24, 2010, at 6:07 PM, Silva Paulo wrote: > From your answer I may conclude that I should use a "non django" solution to > load the database, isn't it? If this is going to be a one-time bulk load, it will certainly be faster. You might consider using the .import command from SQLite's

Re: Massive insertion of records

2010-12-24 Thread Silva Paulo
use a "non django" solution to >load the database, isn't it? --- On Fri, 12/24/10, Christophe Pettus <x...@thebuild.com> wrote: > From: Christophe Pettus <x...@thebuild.com> > Subject: Re: Massive insertion of records > To: django-users@googlegroups.com >

Re: Massive insertion of records

2010-12-24 Thread Christophe Pettus
On Dec 24, 2010, at 9:26 AM, Silva Paulo wrote: > I need to do a massive insertion of records in two tables "connectd" by > "foreignkey". Is there a way, using the Django db API, to do it. > e=Foo(...);e.save() seems too slow. It's always going to be very slow to

Massive insertion of records

2010-12-24 Thread Silva Paulo
I need to do a massive insertion of records in two tables "connectd" by "foreignkey". Is there a way, using the Django db API, to do it. e=Foo(...);e.save() seems too slow. Thanks -- You received this message because you are subscribed to the Google Groups