Brad, Others will undoubtedly talk about file sizing issues.
We had a problem where we had some jobs locking up to 30,000 records where the system was geared to handle, maybe, scores or hundreds of locks. Jobs that should have taken a minute, or less, were taking hours. I wrote a program to count the lines in a captured LIST.READU so that I would know how bad the problem was. In this case we had upgraded to a newer version of vendor supplied software which had a new locking strategy in inventory that affected job costing. This ran into a non-standard "trick" where we used inventory to track certain costs. We did make some helpful system changes to accommodate the larger number of locks but we solved the greatest part of the problem by making procedural changes. Karjala -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniData performance problems We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/