Search results

Hi Tom! I am a beginner in this forum. I will try [C O D E ] next time. And, Yes, the Profiler seems to be more and more necessary! :)

You are right! Progress query should be written as the SQL query. Started with item_price, join item, join agreement. When this was done, the time went down from 37 seconds to 3 seconds. In this code, after the loop was changed to a "3-secondsloop", there was no difference when switching from...

Thanks Tom! My colleagues and I do not think that the code is the bottleneck. Well, the code can of course be improved a bit, which we did. But it has not added much. I enclose an simple example of the difference between SQL and Progress Question. SQL is 16 times faster than Progress. (We have...

Stamford has made a product called CCM that has been developed for 10 years (current version: OE 11.6). Data resides in two SQL databases (Microsoft) and one DB2 database. The application works mainly against the database "CCM-SQL". The front-end (.html) code is written in progress code /...