Subject AW: [firebird-support] Question about better performance Query
Author Olaf Kluge

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.


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.


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

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