Re: EDB delete multiple records question

new topic     » goto parent     » topic index » view thread      » older message » newer message 

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.

Regards,
   Rob Craig
   Rapid Deployment Software
   http://www.RapidEuphoria.com

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu