Re: [Catacomb] problem deleting external resources
ok, solved the problem. Is was not too hard at all.
The database could simply doing the work:
WHERE URI LIKE ? '/%'
AND isexternal =1
Am Freitag, 27. Oktober 2006 14:21 schrieb Markus Litz:
> when recursive deleting a collection, not all external resources under that
> collection are deleted correct.
> Catacomb deletes a collection recursive with only one sql query:
> "DELETE FROM dasl_resource WHERE URI=? or URI like ? '/%'"
> a very good and fast solution. But to detect all resources in the
> collection that should be deleted, maybe thousands of queries had to be
> made in order to detect whether a underlying resource is an external
> resource or not. THAT would be a real brake.
> Does anyone has a good idea on this?