deanable Posted May 24, 2012 Report Share Posted May 24, 2012 Where can I increase the time that SQL queries have to execute? When executing queries (2 users) the server times out and does not return any results... Quote Link to comment Share on other sites More sharing options...
Murat Posted May 25, 2012 Report Share Posted May 25, 2012 With what queries the server times out? It will be better for us to optimize the queries, rather than changing the time-out limits, because there are WFC and Client timeouts also. This issue might be resolved on the next minor update if the problem appears after Folders selection. Quote Link to comment Share on other sites More sharing options...
deanable Posted May 25, 2012 Author Report Share Posted May 25, 2012 It happens when we select multiple folder groups for categorisation. I wish I could give you a benchmark (like saying it happens when you select 20 folders or something like that) but I can't. The queries are more likely to time out when: More than one user is connected Other background tasks like Auto Sync or import is also running Queries increase in complexity The SQL queries' complexity can be reduced by assigning categories (or other non-folder tags) to groups of images... This worked for me. You are right - it is an issue with folder tags... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.