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:
Error: could not create email file in EMailFolder. (2003)
Cart -> Date and Time (2004)
Up and running ... at last !! (1997)
[bug] Technical Support Log Crashes Server (2004)
Count regular expressions in a file (2007)
[WebDNA] [arrayset name=array_1&dim=X,Y,Z] Margins (2012)
Separate SSL Server (1997)
[WriteFile] problems (1997)
Some ThankYou page problems (1997)
Cart Numbers (1997)
Just a thought (1998)
different ship dates and shopping carts -- how to? (1997)
Unexpected comparison behavior change in 4.5.1 (2003)
Date Range search (1997)
WebCatalog/WebMerchant 2.1 (1998)
Searhing for logic (1999)
Separate SSL Server (1997)
Cart Question (1998)
Download (1999)
Locking up with WebCatalog... (1997)