Is there a way to hide rows but still have the data in the dateset to search or filter?

Is there a way to hide rows but still have the data in the dateset to search or filter?

jjp125jjp125 Posts: 6Questions: 2Answers: 0

I have a case now where over 20k rows load and the user is getting an unresponsive message. I was thinking of maybe hiding rows of a certain data type but yet the user would still be able to search or filter the data and the "hidden" rows would show up then.

Answers

  • colincolin Posts: 15,142Questions: 1Answers: 2,586

    This section of the FAQ should help, it discusses various techniques to improve performance,

    Cheers,

    Colin

  • schwaluckschwaluck Posts: 103Questions: 27Answers: 1

    Hi jjp125,

    if you are using SearchBuilder on this table, this might also cause trouble for you.
    We have a table with a lot of rows as well, like 20k, and performance is decreased by the searchBuilder, since it only supports client-side so far (nontheless SearchBuilder is a very, very awesome tool!!).

    Just as a fyi in case you won't find a solution.
    How we tackled this problem:

    Create views in your database based on customers needs, if a dynamic search-function like searchBuilder is needed in the frontend for the user.

    Kind regards,
    Daniel

Sign In or Register to comment.