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 on the 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 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  2. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Grant Hulbert 2004)
  3. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  4. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Dylan Wood 2004)
  5. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  6. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  7. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Dylan Wood 2004)
  8. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Grant Hulbert 2004)
  9. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  10. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Alex McCombie 2004)
  11. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  12. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  13. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Alex McCombie 2004)
  14. Re: (OT) SERVER FREEZES ALL AT SAME TIME ( Dylan Wood 2004)
  15. (OT) SERVER FREEZES ALL AT SAME TIME ( Ross Markbreiter 2004)
  16. Re: Server Freeze...not always (Grant Hulbert 1998)
  17. Re: Server Freeze (Kenneth Grome 1998)
  18. Re: Server Freeze (Peter Ostry 1998)
  19. Re: Server Freeze (Peter Ostry 1998)
  20. Re: Server Freeze (Sid Stary 1998)
  21. Re: Server Freeze (Britt T. 1998)
  22. Re: Server Freeze (Kenneth Grome 1998)
  23. Re: Server Freeze (bob 1998)
  24. Re: Server Freeze (dave spaulding 1998)
  25. Re: Server Freeze (Kenneth Grome 1998)
  26. Re: Server Freeze (Brian B. Burton 1998)
  27. Re: Server Freeze (Kenneth Grome 1998)
  28. Re: Server Freeze (Peter Ostry 1998)
  29. Re: Server Freeze (Sid Stary 1998)
  30. Re: Server Freeze (Brian B. Burton 1998)
  31. Re: Server Freeze (Brian B. Burton 1998)
  32. Re: Server Freeze (PCS Technical Support 1998)
  33. Re: Server Freeze (Kenneth Grome 1998)
  34. Server Freeze (Brian B. Burton 1998)
>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 on the 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 | Typhoon 619/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)