iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
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.
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.
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 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.
Melbin
Hi,
Thanks for the update.Are you planning for any patch fix for this?
or should this be a part of next build ?
Regards
Can u look into this issue as early as possible since its a big issue for us ?
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 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.
WebGrid1.LayoutSettings.VirtualLoadMode = ISNet.WebUI.WebGrid.VirtualLoadMode.Default
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.
That worked .
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname