Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Sat, Aug 10 2019 9:49 AM	Permanent Link
Mike	Some of my reports can take a long time to finish. Is it possible to set some priority level for running queries so they don't bother other functionality in the system? Regards, Mike
Sun, Aug 11 2019 2:51 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Mike The best way is to put them into a background thread then they can just poddle along at their own pace and not annoy the UI. Roy Lambert
Sun, Aug 11 2019 6:50 AM	Permanent Link
Mike	Hi Roy, Yes that would be an idea. I am also interested in the possibility to prioritize queries in the back-end (EDB Server). Is this also possible?
Sun, Aug 11 2019 7:22 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Mike >I am also interested in the possibility to prioritize queries in the back-end (EDB Server). I don't have the source so I can only guess. The server is already putting its work into threads, if it didn't users would always be waiting for one another. It is possible to set thread priorities https://docs.microsoft.com/en-us/windows/win32/api/processthreadsapi/nf-processthreadsapi-setthreadpriority but I think you'd have to modify the source to allow individual queries to take variable priorities. Roy
Mon, Aug 12 2019 3:38 AM	Permanent Link
Mike	Thank you for the info!