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 ...
User site, typical Comet workstation ...
User site, CAW on the same workstation (no Internet) ...
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.
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.