Intersoft Community - WebGrid Enterprise - Virtual Load Mode for LargeData

Virtual Load Mode for LargeData

handy@intersoftpt.com — Thu, 23 Feb 2012 02:09:53 GMT

Hello Frank,

Can your provide us with some details? Also, what is the problem that you currently have?

Regards,
Handy

Virtual Load Mode for LargeData

qafrank1 — Wed, 22 Feb 2012 16:00:06 GMT

Arun,

Have you implemented your final solution for this problem?

I am attempting a similar build, but have been unsuccessful with my solution.

Any tips you could offer would be greatly appreciated.

Virtual Load Mode for LargeData

handy@intersoftpt.com — Fri, 05 Feb 2010 02:37:15 GMT

Hi Arun,

Yes, it will load RequestedRows. E.g uses for top for first load. I don't quite undestand what you mean with "loses the previous set of data loaded". Does the previous data dissapear from WebGrid or something? I think the previous data would still remain.

Also, if you chaned VirtualPageSize into 2000, of course it will take some time to load. We should not compare the performance with load 50 records.

Regards,
Handy

Virtual Load Mode for LargeData

aiyer — Thu, 04 Feb 2010 06:26:30 GMT

Thanks Handy

One thing i noticed is each and evreytime you scroll, it loads data from 1 to RequestedRows (as it uses top)

is their anyway we can specify the Range say 1- 100 first time and then 101-200

I did try this way, but since it goes to the IntializeDatasource for each call, it loses the previous set of data loaded.

Is this possible, this will elimate the no. of records binding each time, also in the sample i gave, change the VirtualPageSize to 2000, you will see that after 3 scrolls it takes double the time for each load.

Change the SQL Squery to the following

WITH lo AS ( SELECT ROW_NUMBER() OVER (ORDER BY ID) AS ROW, * FROM lotable WHERE parent_learning_object IS NULL)
SELECT * FROM lo WHERE Row BETWEEN " & _from & " AND " & _to & ";"

Thanks

Arun

Virtual Load Mode for LargeData

handy@intersoftpt.com — Wed, 03 Feb 2010 20:56:13 GMT

Hi Arun,

Yes, apply the latest hotfixes are required. Otherwise, you will face a total load records like before. I am sure you can see the great performance now. Please let me know if you have another question.

Regards,
Handy

Virtual Load Mode for LargeData

aiyer — Wed, 03 Feb 2010 07:19:55 GMT

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

handy@intersoftpt.com — Tue, 02 Feb 2010 22:24:35 GMT

Hi Arun,

Have you updated into the hotfix link that i refer to you before (see previous posts) ? I tested your sample and it worked well in here. FYI, I only changed the connection string on your sample. As i described at previous posts, you need also to apply the latest WebGrid and WebUIFramework hotfix. Here, I decided to attach them in there.

Regards,
Handy

Virtual Load Mode for LargeData

aiyer — Tue, 02 Feb 2010 14:19:07 GMT

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

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

handy@intersoftpt.com — Mon, 01 Feb 2010 20:57:18 GMT

Hi Arun,

Have you tested out my suggestion and detail codes?
Actually, what you described SelfReference LoadOnDemand performance in ComponentArt is what our WebGrid can also do.
As I said before, you need to handle it in InitializeDataSource for parent.
You can also customize in IntializeSelfReferenceDataSource for child.

For example, I modified the sample you sent me. It work great and the performance was awesome (2-3sec).
If you did not look at my code and suggestion in detail, it would take nearly 15-20min.

FYI, please also download the hotfix based on the link that I gave you at previous post. Hope this helps.

Regards,
Handy

Virtual Load Mode for LargeData

aiyer — Mon, 01 Feb 2010 10:33:42 GMT

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

aiyer — Wed, 13 Jan 2010 07:26:52 GMT

Hi,

We have big performance issue with grid having more than 70k rows.

We are using PagingMode="VirtualLoad" .I read from the grid help file that we can improve the performance my using either VirtaulLoadMode ="custom" or "LargeData".

I will first ask few question on "LargerData"

-------------------------------------

I tried this in a grid with 80k rows ,it loaded quickly.If I apply filter,sort ,is the filter and sort applied only to the initial loaded records(50) or to to full 80krows?Also I noticed the InitializeDataSource event is triggered each time when it tries to load the records and the Stored proecdure is executed each time.Is this the default behaviour or any solution for this?

I read in your site that the grid 'export' will export only the loaded records.Can i put the code to change the VirtualLoadMode="default" and rebinddatasource in the 'Export' event of the grid?

Another issue is grid performace is very low in a grid(10k rows) having selfreference with Load on demand when using VirtualLoadMode="LargeData"?Any solution to improve selefreference grid performace for 'largedata'?

Question on 'Custom'

----------------------------

I read about 'custom'.The problem is I am not using ISDataSource to bind the grid.So how will I use

SelectCount ,Select Method to retrive the records ?

I bind the grid in the InitilizeDatasource event using e.DataSource =mytable.

thanks

Melbin