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


slow performance when using (WebBusinessBindingSource) with aspxgrid...
Author
Message
Jocelyn Dagrain
Jocelyn Dagrain
StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)
Group: Forum Members
Posts: 20, Visits: 127
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.

 
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search