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 > data, but if DSE could

Re: Massive insertion of records

2011-01-07 Thread Derek
ig - > >> > >> On Mon, Dec 27, 2010 at 05:29, derek wrote: > >>> > >>> Can you explain what you mean by "manual commitments" (preferably with > >>> a code example)? > >>> > >>> Thanks > >>> Der

Re: Massive insertion of records

2011-01-06 Thread Thomas Weholt
ou explain what you mean by "manual commitments" (preferably with >>> a code example)? >>> >>> Thanks >>> Derek >>> >>> On Dec 26, 4:38 am, Silva Paulo wrote: >>> > OK. I found a "solution". >>> > Us

Re: Massive insertion of records

2010-12-29 Thread Derek
t;> Derek >> >> On Dec 26, 4:38 am, Silva Paulo 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-27 Thread W. Craig Trader
() > > > > > > --- On Mon, 12/27/10, derek wrote: > > > From: derek > > Subject: Re: Massive insertion of records > > To: "Django users" > > Date: Monday, December 27, 2010, 11:29 AM > > Can you explain what you mean by > > &qu

Re: Massive insertion of records

2010-12-27 Thread Silva Paulo
> 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 all who answered. > > > > --- On Fri, 12/24/10, Silv

Re: Massive insertion of records

2010-12-27 Thread W. Craig Trader
gt; 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 all who answered. > > > > --- On Fri, 12/24/10, Silva Paulo wrote: > >

Re: Massive insertion of records

2010-12-27 Thread derek
very fast (at least for my needs). > > Thanks to all who answered. > > --- On Fri, 12/24/10, Silva Paulo wrote: > > > > > > > > > From: Silva Paulo > > Subject: Massive insertion of records > > To: "newbie" > > Date: Friday, Dec

Re: Massive insertion of records

2010-12-25 Thread Silva Paulo
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 all who answered. --- On Fri, 12/24/10, Silva Paulo wrote: > From: Silva Paulo > Subject: Massive insert

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 com

Re: Massive insertion of records

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

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 slo

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 &quo