The OpenEdge Hive

To collect performance related data, I think VST is the way to go. It is original and nothing beats the original. I feel like I never know enough of them and here is the place I can learn a few "useful" one, There will be "VST two", "VST three", etc.

this writing is the summary of an old document "Progress Tuning Workshop" from 2001.

1. _actSummary
aiming for high commit(high throughput), that's _summary_commits field
look at the _summary_flushed row for the flushed block, that will tell you if you have enough APWs

Soundex sample

Just uploaded a new version of the OpenXML Libraries and tutorial.

Recent updates -

- Added support for resizable images.

- Added support for external, linked images.

- Added numeric and date internationalization features.

- Bug fixes and performance improvements.

You're invited to download the tools and try the samples or just look through the tutorial.

http://www.oehive.org/project/libooxml

If you have any questions please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich

Just uploaded the first version of the OpenXML Libraries tutorial.

http://www.oehive.org/project/libooxml

Please download and read the tutorial.

I'm sure you'll find a few tricks you didn't know about.

Keep checking the project page.

More updates are planned to be released soon including a Free Lite version.

Every once in a while a question comes up in the Progress forums ...

I can't find the sin, cos, tan functions ?

I'm happy to say this question has finally been resolved

thanks to Jeff Pilant who donated the sin, cos, tan functions

to the Progress STandard Libraries (STL) open source project.

http://www.oehive.org/project/lib

/* test-slibmath.p */

{slib/slibmath.i}



define var iDegree as int no-undo.

repeat iDegree = 0 to 360 by 5:

    display
        iDegree                             format ">>9"                column-label "Degree"
  

I've uploaded UNIX/Linux r-code versions for the Word and Excel utils express edition.

Please download the utilities and try the samples.

http://www.oehive.org/project/libooxml

If you have any questions or requests please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich

Version 3 of the Progress Standard Libraries Project is available for download.

http://www.oehive.org/project/lib

Here's a short list of some of the new updates -

1. Backup/Archive/Restore utilities.

2. Salesforce.com integration library.

3. Google API library.

... and many more

Planned updates -

1. 4GL Regex library.

2. Free lite version of the 4GL Query Optimizer.

3. Free lite version of the Word and Excel utilities.

What would you like to add ?

If you have any questions or requests please feel free to contact me.

Alon Blich

New Backup/Archive/Restore Utilities Added to the Progress Standard Libraries Project

Quick overview -

Backup utility -

The backup utility does a full backup and then 6 incremental backups every time it runs for every database.

There's an additional script to backup after images that can be set to run every 15/30 minutes. The backup and after image backup use .lk files and will not interfere with each other.

Archive utility -