I'd buy THAT for a dollar!

Published 17 JUL 2012 at 06:09:00PM by Sprezz

Here at Sprezz Towers excitement is rising about a forthcoming update to S/List that we think our users are going to love. With each release of OI we kept getting reports that S/List was getting slower - and our testing confirmed that this was the case.

So we did what we do best at Sprezz - attacked the problem head on with a radical rewrite of the S/List engine. So for the past year or so we've been working on a new version of SLIST_PRODUCE (the program that does the grunt work for actually creating the report) to eliminate all calls to GET and SET_PRINTER. A few thousand of lines of code later we are finally ready to go public with the results. Now the User Interface remains the same (for now ;)) but the print engine is significantly faster. Those of you with long memories may remember AREV LightSpeed? Well we wouldn't go quite so far as to call it that but we have managed to wring every drop of performance from the product. Your mileage may vary but we reckon that most reports will run several times faster. Take a look at the following figures to see what we mean!

call slist("LIST 1000 SYSREPOS APPID TYPEID CLASSID ENTITYID LANDSCAPE ID-SUPP NOT-CENTRE")
VSPRINTER2 VSPRINTER1 S/LIST EXPRESS
77.956
78.97
79.17
56.368
56.797
56.717
4.349
4.526
4.543
Average 78.699 Average 56.627 Average 4.473
call slist("LIST SYSREPOS")
VSPRINTER2 VSPRINTER1 S/LIST EXPRESS
1099.197
1096.097
1121.036
780.128
776.609
774.843
46.699
46.065
45.938
Average 1,105.443 Average 777.193 Average 46.234
For fairness we repeated the exercise with OList (Oinsight's reporting tool) and got the following results :-\\

call list("LIST 1000 SYSREPOS APPID TYPEID CLASSID ENTITYID LANDSCAPE ID-SUPP")

VSPRINTER2 VSPRINTER1
18.491
18.076
17.789
7.945
8.259
9.21


Average 18.119 Average 8.805



call olist("LIST SYSREPOS")

VSPRINTER2 VSPRINTER1
169.793
169.400
170.111
90.061
89.313
89.199


Average 169.768 Average 89.520