Recent

Author Topic: asynchronous execution of long lasting queries?  (Read 1281 times)

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
asynchronous execution of long lasting queries?
« on: January 26, 2016, 09:28:20 pm »
I have PostgreSQL queries that require extremely long time to finish execution and retrieve resultsets. The execution time can be anything between 30 seconds and 5 hours, in average it is 20 minutes.
Since it is huge time and nothing can be done to enhance query speed, I have to deal with problem how to enable application responsiveness while queries are running in background...I presume not many people are willing to wait with frozen application for  few hours in order to retrieve some query results...
What do you suggest, how to approach to this problem?

Thanks.

balazsszekely

  • Guest
Re: asynchronous execution of long lasting queries?
« Reply #1 on: January 26, 2016, 09:34:53 pm »
@tatamata
Run the queries in a worker thread, this way the GUI is not affected. Just search this forum threaded applications.

 

TinyPortal © 2005-2018