Re: Server Freeze
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17842
interpreted = N
texte = what OS are you using ? machine specs ? www server ?>>>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. > >Yeah the searches are nested. >Yeah, I could write out the info, for kicks I ran just a search of summ=T >for the email address field and used a numfound to see how many originals >there were. in a database of about 5500 records this took 26 seconds (locked >the server) to tell me 5489 were unique. No nested searches were performed. >In the meantime, the server wasn't available for http requests while this >was running. I guess finding unique values is time consuming too, but Why >isn't this a little better multithreaded? > >Also, when sending mass quantities of email, the server locks up while >WebCatalog writes out 5500 files to the outgoing email directory this takes >3 to 5 minutes while the server can't be used. > > Brian B. Burton > BOFH - Department of Redundancy Department >--------------------------------------------------------------- > MMT Solutions - Specializing in Online Shopping Solutions > 973-808-8644 http://www.safecommerce.com
Associated Messages, from the most recent to the oldest:
what OS are you using ? machine specs ? www server ?>>>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. > >Yeah the searches are nested. >Yeah, I could write out the info, for kicks I ran just a search of summ=T >for the email address field and used a numfound to see how many originals >there were. in a database of about 5500 records this took 26 seconds (locked >the server) to tell me 5489 were unique. No nested searches were performed. >In the meantime, the server wasn't available for http requests while this >was running. I guess finding unique values is time consuming too, but Why >isn't this a little better multithreaded? > >Also, when sending mass quantities of email, the server locks up while >WebCatalog writes out 5500 files to the outgoing email directory this takes >3 to 5 minutes while the server can't be used. > > Brian B. Burton > BOFH - Department of Redundancy Department >--------------------------------------------------------------- > MMT Solutions - Specializing in Online Shopping Solutions > 973-808-8644 http://www.safecommerce.com
Sid Stary
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:
emailer w/F2 (1997)
Limit to variables passed on to next tpl? (1998)
Re:quit command on NT (1997)
Ampersand Character (&) (1997)
How far do [showif]s go? (1997)
Purging the .hdr file from cache ... ? (2003)
[OT] Friday Time Waster (2003)
New Site Announcement (1998)
Multiple Pulldowns (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
WebDelivery Text (1998)
Robert Minor duplicate mail (1997)
Date Question (2002)
[WebDNA] improvements (2015)
dos performance (1998)
math/text variable limits per page (2001)
Format of Required fields error message (1997)
WebCat2b13 Command Reference Doc error (1997)
select multiple 2 more cents (1997)
RequiredFields template (1997)