Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
I had to move from standard RPG IV I/O (CHAIN, READ, SETLL...) to using the _ROpen, _RReadn and _RLocate functions in my Copy to CSV routine.
What I'm noticing now is that the time it takes to convert a LARGE database file to CSV has increased substantially over native RPG I/O methods.
Does anyone have any performance tips, documents or webpage(s) that might help improving performance when processing tens of thousands of records with the _Rxxxx I/O APIs.
Hi Bob,
Two things: blocking when you _ROpen, and also not having a separate buffer - using the inbuilt buffer & then setting a pointer to your record structure to the inbuilt buffer. The latter is documented in TFM somewhere. (Library functions where _Rxxx are documented or maybe C programmer's guide).
Thanks Kevin. I'm doing those two things and it hasn't helped. I'm going to play with the SEQONLY and NBRRCDS parameters of the OVRDBF command to see if it helps.