LLBLGenProDataSource binding to Telerik grid SLOW with large collections

Posts   
 
    
apb
User
Posts: 41
Joined: 21-Oct-2008
# Posted on: 19-Nov-2008 00:24:19   

Hi,

I'm using LLBLGenProDataSource declaratively bound to a Telerik grid. I have the grid set to display 10 rows per page.

The entity collection is based on a view with millions of rows.

When I run the page, it basically doesn't return (it does return when I point it at much smaller entity collections).

I have no control over the size of the datasets -- they are what they are. Also, I cannot force the data to be filtered (though the user may choose to add filters).

What am I doing wrong? Doesn't the grid tell the LLBLGenProDataSource that I only want the first ten rows? How can I make a simple grid that pages through a large data set?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 19-Nov-2008 04:50:27   
David Elizondo | LLBLGen Support Team
apb
User
Posts: 41
Joined: 21-Oct-2008
# Posted on: 19-Nov-2008 16:05:54   

Hi,

Thanks for the response. I'm using 2.6.

I had read that link, but it was mostly about LLBLGenProDataSource2. I'm using self-service mode.

While looking at the examples in there again, however, I noticed that they enabled paging on both the grid and the LLBLGenProDataSource. I had only done it on the grid.

Once I set it on the data source as well, everything worked perfectly.

Again, thanks for your help!

apb
User
Posts: 41
Joined: 21-Oct-2008
# Posted on: 19-Nov-2008 16:06:09   

Hi,

Thanks for the response. I'm using 2.6.

I had read that link, but it was mostly about LLBLGenProDataSource2. I'm using self-service mode.

While looking at the examples in there again, however, I noticed that they enabled paging on both the grid and the LLBLGenProDataSource. I had only done it on the grid.

Once I set it on the data source as well, everything worked perfectly.

Again, thanks for your help!

apb
User
Posts: 41
Joined: 21-Oct-2008
# Posted on: 19-Nov-2008 16:07:41   

Sorry about the double post -- getting server error whhen I press post, but apparently it is saving.

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 19-Nov-2008 16:08:48   

Yes, Paging should be set on the datasource, otherwise all records will be retrieved each time you go from a oage to another, and the grid will take care of showing the releveant records.

Setting LLBLGenProDataSource to perform the paging, will only fetch the relevant records when you go from one page to another.