Just wanted to report back to the list what we found.
As Stephen O'Neal suggested, indexes appears to have been the problem. We
found that the process we were concerned about was updating an indexed field
that contains 15 values. In fact, the index contained only 37 unique entries.
In the single-part file, the largest entry was about 65MB. Upon further
inquiry, we found that index was not even useful to the business, so we
eliminated it. A test run on the same machine as was used before showed the
following results:
Single Part Multi-part Single W/o Index
Run time Run time Run time
Batch Process A 00:59:02 00:35:26 01:02:33
Batch Process B 05:42:33 00:28:00 00:57:38
While the multi-part file is still faster, it is now close enough for our
present needs.
Thanks very much for the help!
Richard Lewis
Nu Skin Enterprises
_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
