Services
Support
Store
©2015 Intersoft Solutions. All rights reserved.

User Profile & Activity

Arun Iyer Member
Page
of 4
Virtual Load Mode for LargeData
Posted: February 3, 2010 7:19 AM

Thanks Handy


That explains well,

Thanks a lot guys, the solution you offered work fine. We are able to load large volume of data.

I will reply to the thread once we implement a final solution, so it will be useful for others who are looking for something simillar

Thanks

Arun

Virtual Load Mode for LargeData
Posted: February 2, 2010 2:19 PM

Hi Handy,

I have done exactly what you said in the sample, still i am not getting the result as expected

Please the attached zip file, which has 2 Pages.

Default7.aspx - i used with self reference in this page,  i cant load more records but Self Reference Works.

Default8.aspx - i used without self reference,  i can load more records but Self Reference doesn't Works

In both case i am using the following layout setting

<LayoutSettings VirtualPageSize="50" PagingMode="VirtualLoad" AutoHeight="true" SizeHeightBy="-6" VirtualLoadMode="Custom">
</LayoutSettings>

Can you please advice us what's wrong in the sample i attached

FYI - i have attched an image.doc, in that you can see the output generated

You can also use the same database we submitted in the thread to replicate this issue.

Thanks

Arun

Virtual Load Mode for LargeData
Posted: February 1, 2010 10:33 AM

Guys,

This is not working as expected, i have used VirtualLoad="Custom" but doesn't work with selfreference.

Also if we have more than 100 rows in an Inner child in self reference, how does the grid know to load the next 50 children (when VirtualPageSize="50")


Just to give you guys a statistics which i did today, i download the ComponentArt Grid and used the same datasource with selfreference and LoadOndemand enabled, the grid loaded in 8 sec for the first 50 records.

The same datasource for the first 50 records Intersoft Grid took nearly 15-20 min.

All we are doing is to load first 50 parent records from a pool of 36310 records and when you click the + it will fire another query to get the child and bind the record.

Are you guys saying the grid can't handle this. if so we seriously need to change 25 - 30 pages, which is as good as redesigning the application UI.

I would like to know what is happening in the grid for these many records and we really see this as an issue in the grid failing to Load Large data in Self Reference.

I can't explain more how important this fix is for us.

Thanks

Arun

Virtual Load Mode for LargeData
Posted: January 27, 2010 5:37 AM

Hi Handy,

I would like to know when we are likely to get a fix for this issue.

Just to give you the seriousness of this issue, almost all grids we use are self referenced, and some of our client are loading 65000 records. The screen are unusable as it takes long time to load.

We can use load on demand, which has another issue, if the child tree has got more than 100 records it won't load as we set the VirtualPageSize="100" also since the child doen't realize the scroll of the main grid, it will never load more than 100.

Can you give us a wrokaround atleast till you get a final solution. also please keep us posted in which build (when) this fix will be avilable.

We are heavily dependent on you guys, hope you will come back with a positive answer

Thanks

Arun


Virtual Load Mode for LargeData
Posted: January 20, 2010 4:49 AM

Thanks Handy.

 

It would be great if you could let me know an update as early as possible and send us a patch fix.This is really a major issue for some of our clients using our product.

Thanks

Melbin

Virtual Load Mode for LargeData
Posted: January 19, 2010 3:06 AM

Hi,

Thanks for the update.Are you planning for any patch fix for this?

 

or should this be a part of next build ?

 

Regards

Melbin

Virtual Load Mode for LargeData
Posted: January 18, 2010 4:54 AM

Hi,

 

Can u look into this issue as early as possible since its a big issue for us ?

 

Thanks

Melbin

Virtual Load Mode for LargeData
Posted: January 15, 2010 9:57 AM

Hi,

I am attaching a sample application (gridforintersoft.zip).Inside the zip file you can see the database backup file(gridtestdb) and the test application(WebSite13.zip).Please change the web.config to point to your server.Table lotable is having more than 11k records.It takes 1:50 minutes for load the initial records.When i scroll to load more records it took 2:50 minutes.

These are only parent records.In our real application child will be load by 'load on demand' when plus is expanded.loading child code in not avaialble in this sample code.

Any solution to improve the performance?

Thanks

Melbin

 

Virtual Load Mode for LargeData
Posted: January 14, 2010 8:13 AM

Hi,

Thanks for the answers.

But I found i more thing.InitializeDataSource event is triggered only once when i set the Grid DataCacheStorage="Session" .Also filter and sort is applied to full records now.

Another thing is I tried below code in the Page Load and it exported all the records.

If WebGrid1.FlyPostBackAction = "Export" Then

WebGrid1.LayoutSettings.VirtualLoadMode = ISNet.WebUI.WebGrid.VirtualLoadMode.Default

End If

The performance issue with Selfreference grid is that it takes 4-5 minutes to load 11k records.I am using VirtualLoadMode="LargeData". childs are loaded by 'Load on demand'. If I remove self reference of the grid ,it load very quickly.Any solution?this is a big issue for us as many client have huge amount of rows.

 

Thanks

Melbin

CustomRequest on RowSelect for Self Reference grid
Posted: November 12, 2009 11:17 AM

Hi,

That worked .

Thanks

Arun

All times are GMT -5. The time now is 9:47 AM.
Previous Next