Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
michael larson
90
Disable looping through entire grid child band rows when row is right-clicked?
posted

Hi,

I have run into a significant performance issue with our grid under heavy load testing, with our particular design. (I saw your million row example with a single band, which loaded instantly, so I assume there is a way to improve this issue; but that example was not really the same as this.)

For a 10,000 row grid, the initial grid loads in about a minute or less, which is acceptable. BUT THEN when I right-click a row, another 8 minutes goes by before the context menu appears. Adding some debug, it appears to be looping through FilterRow events for every single child row of every single row in the grid at this time, as opposed to only looking at the children of the row that was clicked.

 

Am wondering if there is an appropriate way to handle the issue via disabling events, different events used, somehow force-tell it to look only at the band immediately under the band clicked, etc.

 

EXAMPLE:

We have an ultragrid which loads linked data from two table.  Customers and Orders (not really, but for the sake of example.)

There might be 50,000 customers.

For each Customer, there might be 1 to 50 orders.

(in my actual test, I had 10,000 rows, but the above numbers are realistic.)

 

Since I want a parent band / child band relationship between the two, I add the two tables, configure the columns, load the data from a SQL query, then add the relationship.

ds.Tables.Add(dtCustomers)            

ds.Tables.Add(dtOrders)            

Dim relAccountID As New DataRelation("ConstEnum", ds.Tables(0).Columns("ACCOUNTID"), ds.Tables(1).Columns("ACCOUNTID"), False)            

ds.Relations.Add(relAccountID)

 

We do have some default sort orders and hidden column and filtering added after the relationship, but I have commented out those blocks, with no change in the behavior described above.

 

Is there some way to force the ultragrid ONLY to look at the child band's rows under the band that row that was clicked?

The initial load times are probably acceptable, given the numbers, but the additional delay is not.

It also appears to be a one-shot delay, as in, in the case of my 10,000 rows, once that extra 8 minute (post right-click) delay has occurred, I can then right click rows freely with normal response time.

I am hoping that is clear enough to sound familiar to you, but if not I can clarify with additional code or information.

 

Thank you very much.

 

 

 

Parents
  • 469350
    Offline posted

    Hi Michael,

    I'm a little confused about what, exactly, is happening. You seem to be saying initially that the problem is due to filtering, but later on in your post you said you turned off filtering and that had no effect.

    Filtering in the grid generally takes place the next time the grid paints on the screen following a change in the filter conditions. 10,000 rows with 50 child rows each should take that long.

    I can't see any reason why the grid should be loaded data when you right-click on a row. Right-clicking is a no-op as far as the grid is concerned. So is your code doing something to the grid when you right-click?

    I suspect there's probably something else going on here - some inefficiency in your code, perhaps in an event handler of the grid, or in the way your grid is set up. But it's impossible for me to guess without seeing it in action.

    I recommend that you take a look at the WinGrid Performance Guide. The guide lists the most common performance issues that come up when working with the grid.

    If that doesn't help, then perhaps you could reproduce the problem in a small sample project and post it here and I would be happy to take a look.

Reply Children