Speed up scrolling of a complex list view

Classic Servoy
1

I’m experiencing a weird issue with a list with a certain amount of calc fields. If I select even only 30/50 records, the scrolling of this form is painfully slow (compared to a similar form in FIleMaker, let’s say 3/4 times slower).
Of course, I know that using a SQL query attached to an html field would solve the problem (always compared to its FileMaker counterpart, I get result in Servoy 600% faster using getDatasetByQuery), but I wanted to know if this kind of slowness can be avoided only using SQL or there are other best practices to adopt in order to use List View, when needed.

Servoy 2.01, OSX.3.3

2

Are you using the scrollbar buttons? or dragging the scrollbar?

3

Jan Blok:
Are you using the scrollbar buttons? or dragging the scrollbar?

Both: the scrollbar buttons, under OSX, are almost unusable even in Servoy Developer (when I switch to Developer mode, the scrolling speed of my G4 733 is comparable to a Macintosh Classic).
Dragging the scrollbar is a bit faster, but too slow either: the scrollbar moves so slow that I don’t see it moving, it appears on a different position after a while.
Just to give you an idea: I selected april payments (137 records) and scrolled them from last to first using scrollbar buttons: it took 1 minute 38 seconds (!)
Even stranger, there was no big difference using Developer or Servoy Client accessing the solution published from Servoy Server.

4

Don’t use list view - use SQL queries and display as HTML within a global text field. Invest in learning this and you’ll find things much easier/faster.

5

Riccardino:
Dragging the scrollbar is a bit faster, but too slow either

In the past the step size of the scrolbar button was to small (1px) this is changed, we never have seen slow scrolling bahavior, is it possible for us to have a look at a client from your server?

6

Jan Blok:
In the past the step size of the scrolbar button was to small (1px) this is changed, we never have seen slow scrolling bahavior, is it possible for us to have a look at a client from your server?

Sure. See details in email :-)

7

cjemichael:
Don’t use list view - use SQL queries and display as HTML within a global text field. Invest in learning this and you’ll find things much easier/faster.

Thanks for your suggestion: I already use SQL/HTML lists, as I wrote in my first post: what I’m trying to understand is if the use of list forms with layout with a certain amount of calcs should be considered a deprecated practice or not.

8

I did have a look at your solution and it seems that some calculations are incorrect. (which indeed can slowdown the scrolling performance)

1)JavaScript error in calculation: monthnr

  1. Exception executing calculation: importo_ammortamento, error: Cannot convert null to an object.

This information comes from the warning sign in the status bar (double click it)