Re: EDB delete multiple records question
- Posted by ags <eu at 531pi.co.nz>
Jul 05, 2005
Robert Craig wrote:
>
> ags wrote:
> > I'm not too worried about this since each scan will be 5 mins apart, but it
> > seems to me to be a missing feature of the EDB system,
> > eg db_delete_multiple(sequence_of_ids)
>
> I can see where deleting a bunch of records at once would
> save a bit of overhead, but I don't think it would be a major
> performance win.
>
> Deletion takes longer when a table has a large number of records.
> Maybe you could somehow have multiple smaller tables.
> Or maybe you could just "mark" records as being deleted, and
> perform the actual deletions when you have more time.
Deleting in reverse iteration seems to work fine. That might be worth a
note in the next release though, I would think it a fairly common issue
given the scope and flexibility of the EDB system.
I thought about marking deleted items, but the system will run 24/7 and have
to perform the task every 5 minutes anyway.
Gary
|
Not Categorized, Please Help
|
|
