Performance tuning in Progress 4GL programs

[jchellap]

Dear All,

I would like to know the ways where we can improve the performance of the progress file(.p).

here are some

1. use of no-undo while declaring variable or other objects
2. using proper indexing while retrieving the data from the database table.
3. replacing cando with lookup
4. using 'for first' instead of 'find first' since we have field options in for first.

Please let me know if you know anything else which can improve the performance of the program

 

[RealHeavyDude]

If you are working with handle-based dynamic objects ( CREATE QUERY, for example ) be sure to delete them so that you won't create memory leaks.

You should also pay attention to buffer and transaction scope.

In order for your .r files to be loaded faster you can use procedure libraries and use the -q runtime startup parameter. But the -q parameter has the side effect that Progress won't load a new version of the .r file per session once it's loaded ...

Never, never, never place temporary files on a network share. Use the -T startup parameter to specify a folder on the local drive.

The single, top most performance killers are non-indexed queries causing the database do heavy disk I/O.

HTH, RealHeavyDude.

 

[jaiprogress]

1) Use Procedure instead of repeating of code
2) Use Temp table

 

[alex28]

There are many sources about 4GL performance tuning. I find the most complete one in this book by Dan Foreman:

http://www.bravepoint.com/products-publications-performance-tuning-guide.shtml




Alex Kim
Phone: 877-348-5432
32 Soft Inc
Excel Data Loaders
High end web applications
P.O. Box 61545 Richmond Hill, ON, L4C 0C9 Canada