We have a routine where the structure of a user defined financial statement gets transferred to a tree view list box. There are four levels in this list box - a major group, a minor group, a line group, and then line details. There are no graphics displayed. Our client has one report that contains 81,141 lines to be loaded into the list box.
The user is in a WindX environment, on a Windows network. They are running PxPlus V15.
I hide the list box before displaying anything. All data is loaded a line at a time. After 65 minutes, approximately 77,000 records had been processed. This is obviously waaaay too slow. I had thought about putting everything into a variable to load everything at once, but I'm worried about error 31's.
Does anyone have any suggestions how to speed up the processing?
Thanks in advance