Hello,
another hint. All table-filds which are read are indicated. Each call of the stored procedure get one result, the pc-program delete the folder and report it to the database (other stored procedure). .until there is no other folder to delete. Thanks. 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] [Non-text portions of this message have been removed]
