We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

too much bandwidth

Thread ID:

Created:

Updated:

Platform:

Replies:

18114 Aug 24,2004 08:25 AM Aug 24,2004 10:34 AM Windows Forms 3
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On August 24, 2004 08:25 AM

hi, in grids and grouping grids bound to datasets and dataviews, how much prefetching do they do. we noticed that over internet connections things get slow. how can we tweak this, hopefully without having to go virtual. tia

Administrator [Syncfusion]
Replied On August 24, 2004 08:43 AM

I think Ado.Net normally uses a disconnected architecture. So, when you do a DataAdapter.Fill the whole request is processed and stored locally, and is used in a disconnected manner until you do an update. Our grids play no role in this. They are just use the disconnected result set in a strictly disconnected manner. So, once a dataset has been retrieved, I do not think there should be further loads on your database until you call dataAdapter.Update. But I may be missing something here.

Administrator [Syncfusion]
Replied On August 24, 2004 10:10 AM

i did suspect the fill, but what if a query is 1 GB, over the internet we''ll be be sitting there an hour at least. i''m just throwing this out there, let me know if you see a fix. would a virtual grouping grid be possible? very difficult i''d imagine. thanks

Administrator [Syncfusion]
Replied On August 24, 2004 10:34 AM

The only way I would know to handle this is to adjust the query so you grab bite-size chunks, allowing you to page your requests. Normally I think people load a separate dataset and then merge the newly retrieved dataset with their already downloaded one. This is all independent of the grid. You can use grid events to try to let you know when you need to fetch another page, but it would be the Frmework actually getting the data and merging it into your dataset. And you would have to manage the paging criteria in some manner. I do not think there would be any advantage to using a virtual gridcontrol in this situation. You would still have to manage the external data some how.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;