Home

Rich Text much slower than Data Grid

I have a statement that when I execute with output = Data Grid, it only takes 1.5 seconds to complete, but if I switch to Rich Text, it takes 1 hour and 20 minutes. I have max rows in Rich Text set to 1000.

It's a simple query.

var pis = PIs.ToList(); pis.Dump();

What could be causing this disparity?

Comments

  • It's using an EF6 DbContext typed data assembly for the connection
  • Does it make any difference if you do this:
    var pis = PIs.ToList();
    pis.Dump(1);
  • That took 1 hour 35 minutes .

    I then ran these in Rich Text mode and got these times:

    PIs.Take(100).ToList().Dump(); = 2.4 sec
    PIs.Take(200).ToList().Dump(); = 10.1 sec
    PIs.Take(400).ToList().Dump(); = 38.7 sec
    PIs.Take(800).ToList().Dump(); = 2min 41s

    Seems exponential.

    Curious, I then ran

    PIs.ToList().Take(100).Dump(); = 9min 12s

    Thinking it might be a column issue (e.g. computed column), I ran

    PIs.Select(p => new
    {
    p.PI_ID,
    p.attn,
    p.PI1,
    p.Active,
    p.type,
    ...
    (rest of the columns, but excluding related objects)
    }).ToList().Dump();

    but that only took 1.6 sec in Rich Text.

    So I started adding in the related object fields (i.e. DEPT = p.DEPT, AREA = p.AREA) to the anonymous object and that's when things started slowing down. If I add only 2 (many:1) of the 7 related objects, the times are Rich Text = 26.7 sec, Data Grid = 2 sec. If I add only 1 (1:many) of the 7 related objects, the times are Rich Text = 31 min 43s, Data Grid = 6.8 sec

    Comparing the generated SQL, when I include the related objects (in the anonymous object) it shows the left outer joins to the related tables, but in my original PIs.ToList().Dump();, it does not - only a single select.

    Note: The PI table has only 20,000 records

    So it appears that the issue is how the Rich Text view handles related objects compared to the Data Grid. 1:many relations are much slower than many:1 relations, but they're both slower when using Rich Text vs. Data Grid
  • FYI, with the new version (5.05.02), this problem still exists. Data Grid = 2 sec, Rich Text = 1:20:33 Is there anything else I can do for you to diagnose this issue?
Sign In or Register to comment.