I have a query that is taking about 90 seconds.  The window times out before any data is displayed.  How do I increase the connection timeout for this query?

Thanks,
Bill

You may also want to look at your database maintenance plan and make sure that the statistics are being refreshed or try analyzing your query in the database engine tuning advisor. I've seen a query drop from 30+ seconds to under a second after tunng. You may also want to consider using the SF Enterprise server to eliminate the database traffic between the client and DB server over your wide area network.

-Larry

Guys, sorry for the super delayed response here.  We have not been in the office (and still aren't) and I have not been able to get the forum until now.

Let me propose another avenue that is much more beneficial to you and the end-user when waiting for large VarBinary(MAX) fields.  StrataFrame has two push methods and two pull methods for this very purpose called: PushBlobField, PushBlobFieldAsync, PullBlobField, and PullBlobFieldAsync.

Whether you choose to use the async method or block and use the non-async methods, this will never timeout and will stream as big of a file that you will ever use.  If you use the async method (which I recommend) you can also add handlers to show a progress bar of the save and/or retrieval.

Push Async Example

The pull will work very much like the push.  This is a great method and is what we do when updating large binary data fields....that is how this made it into the framework

Hi Trent,

When using the Push/Pull methods should the VarBinary fields be included in the BO FieldsToExcludeFromInsert and FieldsToExcludeFromUpdate properties?

Edhy Rijo

Good point.  Yes, they should.