Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 34 total
Thread Filtering in the grid
Fri, Mar 16 2018 11:28 AMPermanent Link

Matthew Jones

I am currently manually filling a grid, but for over a thousand items, it is very slow (tens seconds perhaps to fill, but feels ages). I have a filter mechanism such that it can be restricted to matches, but that then has to delete and refill. Filters are faster because less to do, but then you clear the filter and it takes ages again.

So I need to be able to filter much more rapidly. I could fill a database table or whatever it is that stores the data, and apply that to the grid? The grid is quite customised at run-time as I have about ten variations of the data to be displayed. But I could probably have a single table spec, and empty rows as appropriate.

But can I filter that table for display into the grid any faster? Or would I copy from one table to another? How fast is that? All items have a GUID for their ID, if that helps or hinders.

Is the grid "virtual" from a database table? That would probably resolve most of the issues.

Any suggestions welcome.

--

Matthew Jones
Fri, Mar 16 2018 12:18 PMPermanent Link

Mark Brooks

Slikware

Avatar

Will any user want to actually scroll through and work with 1000+ items though?
Fri, Mar 16 2018 12:44 PMPermanent Link

Walter Matte

Tactical Business Corporation

Web based solutions are better served from short trips to the server for small amounts of data rather that hosting 10,000 records in the client side (and filtering over and over.....really... why?) - I think a redesign is in order here..

Just my 2 cents.

Walter
Fri, Mar 16 2018 12:48 PMPermanent Link

Matthew Jones

Mark Brooks wrote:

> Will any user want to actually scroll through and work with 1000+ items though?

LOL. Two responses basically the same. The simple answer is yes. My existing solution does filtering, does aim to reduce display, but yes, this is something that the customer wants, so the customer needs to have it.

--

Matthew Jones
Fri, Mar 16 2018 2:45 PMPermanent Link

Mark Brooks

Slikware

Avatar

"Matthew Jones" wrote:

>>LOL. Two responses basically the same. The simple answer is yes. My existing solution does filtering, does aim to >>reduce display, but yes, this is something that the customer wants, so the customer needs to have it.

Ok, given you have a customer demand, next proposal is paging, implemented server-side
Fri, Mar 16 2018 3:10 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Matthew

<< Or would I copy from one table to another?>>

Have you considered using views rather than copying tables?

Also, if you use scalar queries in the column list, you can make the view sensitive. For example,

CREATE VIEW "StudentMaxResults1" AS
SELECT
   FullName,
   Score AS MaxScore,
   CourseID,
   (SELECT CourseName From StudentCourses SC2 WHERE SR0.CourseID = SC2.ID) AS Course
 FROM StudentResults SR0
 WHERE
  <more>

Richard
Fri, Mar 16 2018 3:17 PMPermanent Link

Matthew Jones

<Mark Brooks> wrote:
> "Matthew Jones" wrote:
>
>>> LOL. Two responses basically the same. The simple answer is yes. My
>>> existing solution does filtering, does aim to >>reduce display, but
>>> yes, this is something that the customer wants, so the customer needs to have it.
>
> Ok, given you have a customer demand, next proposal is paging, implemented server-side
>
>

Getting the data takes moments. It is the grid specifically that is the
problem. Let’s focus on that!

--
Matthew Jones
Fri, Mar 16 2018 4:23 PMPermanent Link

erickengelke

Avatar

Matthew Jones wrote:

<Mark Brooks> wrote:
> "Matthew Jones" wrote:
>
>Getting the data takes moments. It is the grid specifically that is the
>problem. Let’s focus on that!

BeginUpdate
...
EndUpdate


That way you aren't redrawing the grid constantly, just after ALL the updates are done.

Erick
--
Matthew Jones
http://www.erickengelke.com
Mon, Mar 19 2018 5:31 AMPermanent Link

Matthew Jones

erickengelke wrote:

> BeginUpdate
> ..
> EndUpdate

Already active...

--

Matthew Jones
Mon, Mar 19 2018 5:31 AMPermanent Link

Matthew Jones

Richard Harding wrote:

> Have you considered using views rather than copying tables?

I was thinking in the EWB layer, not on the server.

--

Matthew Jones
Page 1 of 4Next Page »
Jump to Page:  1 2 3 4
Image