Database timeout errors

  
Hi,

I understand that optimizing the query is the first thing you should do when you are encountering 'Timeout expired' errors. But if the query still takes >30 secs, is it possible to simply deactivate or lengthen the timeout property of a query (just like you can do in C#)? This would be very helpful for some long-running big statistical queries in some of our applications.

Thanks,

Jurriaan
If you are receiving timeout errors accessing the database you can:
- Review the query or entity action
- Create indexes in the affected entities
- Try again later
- For more information refer to the "Performance Tuning for OutSystems Applications" Technical Note


If you have database administrator permissions you can also:
- Analyze a database load using Microsoft Index Tuning Wizard
- Review database system memory requirements
- For more information refer to the “Hub Server Capacity Planning Calculator” Document

Hi,

Is there a workaround to run an advanced query for >30 seconds, when you cannot change the indexes and it just need to run that long for only once in a while?

Thanks,

Jurriaan
Yes,
You can do that query in an extension and use the OleDbCommand.CommandTimeout Property.
Keep in mind that most of the times a rearchitecture of the query is really the best approach.

The requirement for exposing this property will also be addressed in a future release.

Hope this helps.