Login | Register
My pages Projects Community openCollabNet

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Catacomb] problem deleting external resources



ok, solved the problem. Is was not too hard at all.
The database could simply doing the work:

SELECT *
FROM dasl_resource
WHERE URI LIKE ? '/%'
AND isexternal =1

Greetings!
Markus

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?