Posted by jimguerber on September 28, 2015 at 13:45:31:
In Reply to: CAW32 problem posted by Grant Foraker on September 22, 2015 at 14:39:23:
Sorting and the speed of light.
You are telling microsoft to sort all of the list box records when they are inserted into their list. This causes windows to perform a sort for each addition. Microsoft never expected that many items to be inserted, and their sort algorithm can't do 1691 sorts or 664 sorts in a very timely manner.
Also, it takes much longer than 3 minutes for me to load those list boxes from here in Hawaii. More like 30 minutes!
Each time you insert a record, windows must turn around and send back a result code. This turnaround costs time depending on internet distance. I do not know how to shorten this time. I do not think there is code in comet to send multiple list items at one time. The best I can recommend is to pre-sort the records and send only a few at a time.
I am really out of my depth here. Does someone else have an idea?
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.