Re: unique ascending numbers
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50204
interpreted = N
texte = However, since this solution is *only* available on v5, it is not an option to those of us who continue to use v4.x whether by our own choice, or because we simply have no other choice. >However, in this case, using the autonumber feature is much better then >using external code to generate the 'next highest' number. This is because >the code to generate the new value is embedded within the Append and Replace >(with append=T) engine code where the database has already been locked >exclusively for modification. If you use external WebDNA to do a >preliminary search, you must also 'wrap' that code with an exclusive lock to >ensure that two threads do not enter your number generating code at the same >time. So, in addition to the extra overhead of the search, you also have >the overhead of the exclusive lock context. The 'autonumber' feature is a >safer more efficient approach. > >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of >> Kenneth Grome >> Sent: Friday, May 09, 2003 10:14 PM >> To: WebDNA Talk >> Subject: Re: unique ascending numbers >> >> >> >At 7:26 PM 5/9/03, Nitai @ ComputerOil wrote: >> >>On 9.5.2003 19:06 Uhr, Marc Kaiwi
wrote: >> >> >> >>> Humm, I was hoping to avoid throwing in an extra search just to >> >>> retrieve the last SKU number in the db. (I have a thing >> about extra >> >>> processing simply because it's easy) >> >> >> >>Do you have 5.x? If so then use &autonumber=field and you >> are done, no extra >> >>processing! >> > >> >You don't know that. You can say that it's easier to code for use >> >mere mortals, but do we know that the processing behind >> >&autonumber=field is less CPU intensive then a search to find the >> >maximum value in a field and then adding one to it? >> >> >> Your question is also relevant to the engine's shopping cart code vs. >> external code that does the same thing. I learned a very long time >> ago that when I use my own external shopping cart code, it runs a lot >> faster than webdna's internal code. >> -- >> >> Sincerely, >> Kenneth Grome >> ------------------------------------------------------------- >> My programmers will write WebDNA code for you at $27 an hour! >> ------------------------------------------------------------- >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://webdna.smithmicro.com/ -- Sincerely, Kenneth Grome ------------------------------------------------------------- My programmers will write WebDNA code for you at $27 an hour! -------------------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
However, since this solution is *only* available on v5, it is not an option to those of us who continue to use v4.x whether by our own choice, or because we simply have no other choice. >However, in this case, using the autonumber feature is much better then >using external code to generate the 'next highest' number. This is because >the code to generate the new value is embedded within the Append and Replace >(with append=T) engine code where the database has already been locked >exclusively for modification. If you use external WebDNA to do a >preliminary search, you must also 'wrap' that code with an exclusive lock to >ensure that two threads do not enter your number generating code at the same >time. So, in addition to the extra overhead of the search, you also have >the overhead of the exclusive lock context. The 'autonumber' feature is a >safer more efficient approach. > >> -----Original Message----- >> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of >> Kenneth Grome >> Sent: Friday, May 09, 2003 10:14 PM >> To: WebDNA Talk >> Subject: Re: unique ascending numbers >> >> >> >At 7:26 PM 5/9/03, Nitai @ ComputerOil wrote: >> >>On 9.5.2003 19:06 Uhr, Marc Kaiwi wrote: >> >> >> >>> Humm, I was hoping to avoid throwing in an extra search just to >> >>> retrieve the last SKU number in the db. (I have a thing >> about extra >> >>> processing simply because it's easy) >> >> >> >>Do you have 5.x? If so then use &autonumber=field and you >> are done, no extra >> >>processing! >> > >> >You don't know that. You can say that it's easier to code for use >> >mere mortals, but do we know that the processing behind >> >&autonumber=field is less CPU intensive then a search to find the >> >maximum value in a field and then adding one to it? >> >> >> Your question is also relevant to the engine's shopping cart code vs. >> external code that does the same thing. I learned a very long time >> ago that when I use my own external shopping cart code, it runs a lot >> faster than webdna's internal code. >> -- >> >> Sincerely, >> Kenneth Grome >> ------------------------------------------------------------- >> My programmers will write WebDNA code for you at $27 an hour! >> ------------------------------------------------------------- >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > >Web Archive of this list is at: http://webdna.smithmicro.com/ -- Sincerely, Kenneth Grome ------------------------------------------------------------- My programmers will write WebDNA code for you at $27 an hour! -------------------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Way off topic!! (2003)
international time (1997)
Email Attachments (1998)
ConvertWords (2002)
Help! WebCat2 bug (1997)
WCS Newbie question (1997)
DNS Lookup 2 (2000)
OS X permissions to write to Globals directory (2003)
capitalize each word? (2002)
Using WebCat for product info requests (1997)
IE-caching (1998)
quick GREP question (2001)
Flash loadVariables (2003)
WebCat2 beta FTP site (1997)
Here we go again... (2006)
Encrypted Templates Serving as Text (2000)
Whats wrong with this code? (1998)
unable to launch acgi in WebCat (1997)
Eudora Plugin (1999)
File type (2000)