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:

2nd WebCatalog2 Feature Request (1996) Need help... (1997) PIXO (1997) I forgot (1998) Multiple Pulldowns (1997) Check Boxes (2000) MacActivity and PCS (1997) off topic fetch vs PCS photomaster (1997) Sending E-mail (1997) Re1000001: Setting up shop (1997) Applescript error (1998) Adding multiple items to Cart at one time, & append contextproblem (1998) PCS Frames (1997) Username for Admin Group (1997) Loosing Quantity (2000) Number of Line Items (1998) passing variables - problem (1997) Further tests with the infamous shipCost (1997) [sendmail] on NT? (1997) Bug Report, maybe (1997)