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.
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.