Post reply

Get the result based on some threshold values

  • May 22, 2017 at 6:36 am

    #336997

    Hi Team,

    I have an requirement of displaying the 2M transactions in datagridview and it is taking too long time to load.
    I tried the following approach grouping the name of the first letter and setting the threshold value to 100000.

    but not getting how to do.. i have loaded the transaction with their transaction count in one table as below
    Count    Name
    10000       A
    50000       B
    101000     C
    500000     D

    Now i want the result in following way

    count    name
    60000    A,B
    100000   C
    101000   C1,D
    100000   D1
    100000   D2
    100000   D4

    So on ... please help me over this.. or is there any better way to display 2M transaction ..(. pagination not required here ).

  • May 23, 2017 at 7:59 am

    #1943791

    Not sure how someone can view 2 million rows or even 1 million at once. It doesn't sound like a sound requirement so maybe it should be revisited.
    Not sure why paging wouldn't be needed since it's often used for large amounts of data like this. And do all of these fit on a single screen when whoever requires this is viewing the data?
    There are lots of examples of stored procedures with pagination available. It may not be required but I would really considering using something like this.

    Sue

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply