Hello Set,



the picture-path can be the status 1 (inserted), status 5 (storage-time has
expired and picture can be deleted) and status 6 (release to delete). A
NIO-Ray-image will be deleted after 2 month, a IO-ray-image after 72 hours.
If all pictures are deleted, I can delete the entire folder (no more
pictures in it).



Now, your query takes 2 minutes before I get the result. We are using
firebird 2.5 cs on server 2008 new version an a lot of cpu and ram-power.



Should I send a test-db? I'm confused. The duration of the execution has
grown with the database size.



Thanks foru your help.





Best regards.



Olaf







[Non-text portions of this message have been removed]