Re: Server Freeze

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17838
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.Are you nesting your searches, is that what's causing the slowdown?I thought we discussed this -- and ways to eliminate the problem -- in an earlier thread.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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.Are you nesting your searches, is that what's causing the slowdown?I thought we discussed this -- and ways to eliminate the problem -- in an earlier thread.Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

What about this [delete] situation? (1998) apparently to problem isolated (1997) WebCat & Oracle (2001) TCP connect, how long does it take (PCS please) (1999) Help name our technology! (1997) Signal Raised Error (1997) [WebDNA] Clean URLS job - will pay (2010) [WebDNA] How to code a 301 redirect (2008) Bug Report, maybe (1997) WebCat2 beta 11 - new prefs ... (1997) Can't find one of the WebCat examples anymore - found it! (1999) Browser Info.txt (1997) [WebDNA] Reformatting database headers (2009) The Form authentication trick (2000) WebCommerce: Folder organization ? (1997) Firesite Round 2 (1999) Showing unopened cart (1997) Search for starts with and ends with? (2003) Exclamation point (1997) redirect tag (2004)