Hi, Just got back from a short break camping so sorry for the late reply.
What would you call a really big transaction? I look at it like this. You have to write the data away, you need the next seq number, so everyone else can wait. How long does it take to write away data to disk? We split lots of the seq numbers down. We use the cost center that the user works in as part of the record key. This means lots of control records but not many problems. It all revolves around getting the lock on the control record first. Think of how a manual system would work. Someone wants to put a file in a filling cabinet but someone else is already there, they wait for the other person to finish what they are doing. The amount of time you have to wait is minimal. The only problem you get is when someone new comes along and doesn't understand about locking the control record first. Hope this helps Les. (only another 150 EMails to read) -----Original Message----- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: 16 June 2005 04:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO... Ah-HA! Some real world transaction experience! Just what I wanted, Les. From: Les Hewkin > Start trasnactions > Readu control record then > record.ID = control record > write record > control record += 1 > write control record > end > end transaction > > This seems to work for us. We do have loads of control > records for generating ID and we never have any missing > numbers. And for really big 'trasnactions', where there is a lot of other writes mixed in, having the control record locked for the duration of the transaction is not a bottleneck for you? That was my main concern. cds ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/