in reply to [solved] Long-running DB query makes Tk application unresponsive
Can you change the query? I had performance problem in my web app recently and to solve it I changed the algorithm.
For example, you can use LIMIT in your SQL, and you don't want to show 1000 records in one screen anyway. So you only query for the first 50 results and when the user scroll down to the 51st result, you query for the next 50 results.
Or you probably want to process some of the data offline, so that your query can run much faster.
cheers,
|
|---|