Adam, I hate to contradict you, but the system *HAS* outgrown its design! In a previous job, we had the exact same problem with serialised stock, and eventually we had to bite the bullet and re-architect with a more-normalised 'traditional SQL' joining table instead of embedded multi-values.
We ended up with a table with attributes (IIRC) of <date>*<time-milliseconds>*<port #> as ID, Stock #, Serial #, Order #, Line #. We may even have stuffed Customer # in too, as a de-normalised performance-improver on reporting, I can't remember now, it was quite a few years ago. And several UV indices to give access reasonably quickly. The pain was significant, and the system became probably on average a tiny tad slower - not enough for users to notice, though. The change did stop the l-o-n-g pauses, which users certainly did notice, while UV grew a record from a very large size to a little bit larger to add another serial number to a sales record. YMMV as usual Regards Mike > -----Original Message----- > From: owner-u2-us...@listserver.u2ug.org On Behalf Of Adam Taylor > Sent: Friday, 24 April 2009 10:57 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Record Size Limit in UV > > Our scenario isn't so much outgrowing its design as expanding > upon its design. Basically what happened was due to > accounting requirements, we had to make a change to our > company's inventory process to move it from a mixture of > serialized parts (for large-ticket items) and non-serialized > parts (for small-ticket items) to have everything be > serialized. Combined with the fact that some of the orders > our customers place have line items with small-ticket items > where quantities range into the multiple thousands, this > causes very large amounts of data to be stored in the serial > number field of the records. > > We are already seeing a performance hit in certain areas with > these instances. Fortunately they are not completely common > occurrences, but they do occur frequently enough that we have > had two or three instances of connections timing out on some > of our users since we made the conversion three months ago. > > Adam Taylor > Program Manager > 713.795.2352 > www.INXI.com > > > [snip] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
