Re: Sample program using STL Container (MAP)

[ Follow Ups ] [ Post Followup ] [ Forum ]

Posted by Grant Foraker on August 21, 2018 at 09:11:55: Uploaded files: 2

In Reply to: Sample program using STL Container (MAP) posted by Robert G Laurin on August 14, 2018 at 12:27:33:

Added STL MAP logic to JTE.IBS. Using a secondary index, I'm able to narrow down a 2 million plus, 10 year audit file to 200K plus records to review. Look for "2018".

The old logic creates a work file on the server and stores the selected records there. Later, the selected records are copied to a CSV file and launched. 130K records in the CSV file.

New logic replaces the workfile with a STLMAP. Used # Buffer to get around single variable limitation.

Development laptop ...

Old 1:10
New :45
36% faster

User site, typical Comet workstation ...
Old 8:36
New 6:22
26% faster

User site, CAW on the same workstation (no Internet) ...
Old 8:45
New 5:55
33% faster

Could make this faster if the CSV was created in TMP.

Definitely worth doing.

Now on to try a STL MAP where the "container" is used for accumulation of totals.

Follow Ups:

Post a Followup



What is the name of the main Signature System's Product?  


Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Forum ]