Re: Server Freeze
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17839
interpreted = N
texte = >So once again I'm searching for duplicate email addresses in a database (now>5500 records). It locks up the server doing 5500 searches and 30+million>comparisons There has to be a better way to do this.I really like your neighbor's idea of writing out a new database based onthe summary search. This is definitely the fastest way to go.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>So once again I'm searching for duplicate email addresses in a database (now>5500 records). It locks up the server doing 5500 searches and 30+million>comparisons There has to be a better way to do this.I really like your neighbor's idea of writing out a new database based onthe summary search. This is definitely the fastest way to go.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Simple Database close connection (2001)
What am I missing (1997)
Rhapsody? (1997)
Follow-up to listfiles bug report ... (2003)
SMSI: WebDNA Versions? (2002)
Credit Card Number Stripping Digit (1997)
TCP connect, how long does it take (PCS please) (1999)
Emailer error codes (1999)
URL too Long? (1997)
Where's Cart Created ? (1997)
Re2: Calculating multiple shipping... (1997)
Roundup function? (1997)
Emailer 1.0.2 Conflicts? (1998)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
URL for Discussion Archive (1997)
[WebDNA] listvariables (2014)
Encrypt Decrypt URL UnURL Weirdness (2001)
Encrypt and Commit Me (1998)
Jimmy Houssen (1998)
[WebDNA] OT - does anyone know how to get Fetch/BBedit to leave my last line-ending char intact? (2009)