On Apr 17, 11:57 pm, koranthala <koranth...@gmail.com> wrote:
> On Apr 17, 11:51 pm, Alex Gaynor <alex.gay...@gmail.com> wrote:
>
>
>
> > On Fri, Apr 17, 2009 at 2:47 PM, koranthala <koranth...@gmail.com> wrote:
>
> > > Hi,
> > > I am facing a problem which I believe should be a usual issue for
> > > everyone. But I cannot find a way to do it in a straightforward
> > > manner.
> > > I have to select a list of items from table A and delete everyone
> > > of them. Now, there are close to 20K elements which I want to delete.
> > > So, what I do now is:
> > > fields = tableA.filter(******)
> > > for field in fields:
> > > field.delete()
>
> > > Now, this is invoking 20K separate messages to the DB - which is
> > > rather suboptimal. However I think, I could not find a mechanism to
> > > delete it in a straightway. One option I could think of is to create
> > > raw SQL and invoke - but I would like to do that as the last resort.
> > > Is there any other mechanism to do the same?
>
> > tableA.objects.filter(...).delete()
>
> > Won't pull in each of the objects to delete
> > them:http://docs.djangoproject.com/en/dev/topics/db/queries/#topics-db-que...
>
> > Alex
> > --
> > "I disapprove of what you say, but I will defend to the death your right to
> > say it." --Voltaire
> > "The people's good is the highest law."--Cicero
>
> Thank you Alex.
Sorry for troubling everyone further. But, I had a similar case of
insert too - wherein I insert close to 2K elements at a time.
Currently, I do it as
list = []
...
in some loop
...
table = Table(values)
list.append(table)
...
for l in list: l.save()
Is there something similar to block delete - for block insert 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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
