a Point of VIEW: circumvent for "SSP slower in U9 as in U8"

Author: ulrichmerkel@web.de (ulrich-merkel)

In U9, using SSP is feelable slower than it was in U8.
CPWR is working on a performance improvement right now.

In the meantime, we have a way to circumvent the problem:

Create a view which calls the stored proc and has all the parameters as fields as well as the results from the SP.
Now you can use the standard uniface retrieve mechanism.

We have only very simple Procs and we clustered these in to views based on the underlying tables to reduce the amount of views.
But we got nearly our U8 speed back in the application.

Would be nice to learn the experiences of someone with a more complex scenario.


This page has no comments.