Re: unique ascending numbers
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50217
interpreted = N
texte = On 9.5.2003 23:16 Uhr, Joe D'Andrea
wrote:>> 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?Joe,Scott explained it to me that with the autonumber it is more efficient.We have run into problem were only 5 people tried to add a new record. The template was giving each a new ID. Well, it happened that some of them got the same ID.So we have to wrap [exclusivelock] around the search to find the next higher value and then do a append. I think &autonumber=ID is better:-)Sincerely, Nitai Aventaggiato CEO-- Tools to energize your business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Unionstrasse 4 info@computeroil.com 8032 Zürich/Switzerland Tel: +41 (0)43 333 1 555 ------------------------------------------------------------- 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:
On 9.5.2003 23:16 Uhr, Joe D'Andrea wrote:>> 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?Joe,Scott explained it to me that with the autonumber it is more efficient.We have run into problem were only 5 people tried to add a new record. The template was giving each a new ID. Well, it happened that some of them got the same ID.So we have to wrap [exclusivelock] around the search to find the next higher value and then do a append. I think &autonumber=ID is better:-)Sincerely, Nitai Aventaggiato CEO-- Tools to energize your business Content Management & eBusiness SystemsComputerOil GmbH http://computeroil.com/ Unionstrasse 4 info@computeroil.com 8032 Zürich/Switzerland Tel: +41 (0)43 333 1 555 ------------------------------------------------------------- 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/
Nitai @ ComputerOil
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:
More help for discount pricing (1998)
Credit Card not accepted (1998)
getting images' width/height (1998)
WebCat2 beta 11 - new prefs ... (1997)
[Sum] function? (1997)
Freeze (2003)
WC2b12: Yes, Formulas.db is for real (1997)
WebDNA Solutions ... sorry! (1997)
denied access (1997)
Reversed words (1997)
Error Messges (1997)
includes and cart numbers (1997)
faxing orders (2000)
Process SSI and WebCatalog.acgi (1998)
unsubscribe (1997)
RE: Quantity (1998)
Forms Search Questions (1997)
WebCat2b15MacPlugin - [protect] (1997)
Help! WebCat2 bug (1997)
WebCatalog can't find database (1997)