Timeout on a really fast query : Does it always time out? It...

Wed, 28 Dec 2011 08:49:50 -700

Author: kimj
Subject: 3182
Posted: 28-Dec-2011 at 8:49am

Does it always time out? It may be that the timeout isn't coming from the database but is instead a communications timeout. Looking at the exception and all inner exceptions may help indicate where the timeout is originating. If it is a communications timeout, then my first thought would be to check the NotesResult class to be sure it's serializable and defined on both client and server.

Timeout on a really fast query : Hello IdeaBlade,I'm currently...

Wed, 28 Dec 2011 02:51:06 -700

Author: pponzano
Subject: 3182
Posted: 28-Dec-2011 at 2:51am

Hello IdeaBlade,
I'm currently facing troubles when executing a simple stored procedure that executing from SQLServer manager returns in 1-2 second...calling it from my WPF applicazion takes a lot of time and it goes in timeout (other stored procedure that takes 20-40 seconds run fine)

my call is :

    public void LoadData()
        {
            IsBusy = true;
            CanPrintExport = false;

            _repository.LoadNote(App.LoggedUser.IDIstituto, Date,
                           results =>
                           {
                               ResultList = new BindableCollection(results.Cast());

                               CanPrintExport = true;
                               IsBusy = false;
                           },
                                      e => MessageBox.Show(e.Message));

        }

and here's my call to the stored procesure in applicationrepository

   public INotifyCompleted LoadNote(int idIstituto, DateTime date, Action onSuccess, Action onFail)
        {
            var query = Manager.myStore(idIstituto, date);

            query.CommandTimeout = 60; //this can be 180 ...always got the same problem

            var op = query.ExecuteAsync();

            return op.OnComplete(onSuccess, onFail);
        }

The strange thing is that a lot of time elapse between the load button click and the RPC completed on the Sql Server profile to appear..

Thanks
Paolo

DevForce Community Forum : Timeout on a really fast query

Timeout on a really fast query : Does it always time out? It...

Timeout on a really fast query : Hello IdeaBlade,I'm currently...