If you are meaning "Across the entire system" as in multiple computers, make sure you are synchronizing time from a common source. If you have Unix systems, running NTP / XNTP services or equivalent and synching with multiple (at least 3) stratum 2 time servers, then syncing internal systems with your time servers would be needed.
Bob Gerrish Kingsgate Enterprises, Inc. At 05:14 PM 6/27/2005, you wrote:
The thing is I do not want to end up with a bottle neck as the idea behind this is to create a log of transactions across the entire system which can then be used to replicate the data into SQL Server in sequential order. So I want a system wide sequential ID not per file. Using time and looping if the key exists will allow me to do this, as I have down to milliseconds for the key. However the regular time can be effected by Daylight savings time and I want to guarantee time order. Cheers, -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Tuesday, 28 June 2005 11:45 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] - Determining time sequence Maybe you should (re)read the thread on sequential IDS --> simply have a "counter" that you increment and you can then be sure to maintain the correct sequence of events. If you want you could then add time() as part of the key, but the REAL, absolute sequence is then derived from your sequential ID, and the noted time is simply ancillary documentation Ross Ferris Stamina Software Visage - an Evolution in Software Development >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of phil walker >Sent: Tuesday, 28 June 2005 8:38 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] - Determining time sequence > >I need to generate a timebased sequential key which is independent of >daylight savings time, so that I can consistently know in what order >transactions took place even when they occur over the daylight saving >time changes. > >I have found the following in the help system about the BASIC SYSTEM(99) >function: > > Returns the system time in the number of seconds > since midnight Greenwich Mean Time (GMT), January > 1, 1970. > >And initially thought I could use this function, but after some testing >are having doubts. Has anyone else done something similar to this? > >Cheers, >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
