StrataFrame Forum » StrataFrame Application Framework - V1 » WebForms (How do I?) » slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

Jocelyn Dagrain — Tue, 10 May 2011 11:04:01 GMT

Bonjour

I had only positive experiences with strataframe on window application.

I decide to push the product at my company but they only want web application.

To prove my point that strataframe will be the best framework for us, I created a small web application that load 800 rows of data from a BO.

But to my surprise we had slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

I have a store procedure that return 800 rows, from the BO CusMaximoBO I am able to display the data, but when I navigate with the paging it seem that the 800 rows are reload each time I clique on a page number.

I know that doesn’t make sense since the call to the store procedure via CusMaximoBO only append once on the load event because off the Ispostback.

<SFWeb:WebBusinessBindingSource ID="WebBusinessBindingSource1" BusinessObjectName="CusMaximoBO" runat="server">

    </SFWeb:WebBusinessBindingSource>

protected void Page_Load(object sender, EventArgs e)

        {

            if (!this.IsPostBack)

            { this.CusMaximoBO.GetMaximo(false); }

            }

        }

Also when we connect the aspxgrid directly to the sqldatasource when we navigate from page to page is very fast the we don’t even see the progress bar.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:AIMITConnection %>"
        SelectCommand="GetMaximoPO" SelectCommandType="StoredProcedure">
        <SelectParameters >

Can you help me ? Thank you in advance.

RE: slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

Jocelyn Dagrain — Tue, 10 May 2011 11:04:01 GMT

Bonjour

Any news about the new version of strataframe do you know if the WebBusinessBindingSource and web application aproach will be improve.

I would like to put these informations in my (business case) to submit to upper management.

Thank you

RE: slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

ChanKK — Thu, 05 May 2011 04:01:29 GMT

[quote][b]Jocelyn Dagrain (5/3/2011)[/b][hr]Bonjour

Thank you for the fast respond
Before trying the temporary solution proposes by this message http://forum.strataframe.net/FindPost29882.aspx
(What I tried to do is expose the instance of BusinessBindingSource used by WBBSEnumerator, then on page_unload, dispose it.)

If it possible can I have the opinion of Strataframe team just to make sure they support that work around

Merci.

[/quote]

I wish what you wish too!

RE: slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

Jocelyn Dagrain — Tue, 03 May 2011 13:26:07 GMT

Bonjour

Thank you for the fast respond
Before trying the temporary solution proposes by this message http://forum.strataframe.net/FindPost29882.aspx
(What I tried to do is expose the instance of BusinessBindingSource used by WBBSEnumerator, then on page_unload, dispose it.)

If it possible can I have the opinion of Strataframe team just to make sure they support that work around

Merci.

RE: slow performance when using (WebBusinessBindingSource) with aspxgrid from devexpress 10.2

Edhy Rijo — Mon, 02 May 2011 19:42:31 GMT

Hi Jocelyn,

I found this message in the forums that may be related to the issue you are having http://forum.strataframe.net/FindPost29882.aspx

There are more posting in the forums related to aspgridview that may be also related.

Good luck!