Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41329
interpreted = N
texte = You're right, but in my experience to date, doing a simple append to like a 5 or 10 meg database will completely lockup Webcat for several minutes.So I've always avoided doing massive writes/replaces/appends like plague.If I could do a single search in SQL, and not lockup the primary web server doing it, that would be good.On Mac OS, spawn has never worked right, and while I'm planning on implementing this on OSX on a DP 533 or maybe even a DP xserve, I'm a little reluctant to try and write out that much data.--a little while later--Well, I just did a test, (on my powerbook mind you) and webcat wrote a 500k line file to 37 MB file in 1986 ticks. So maybe I'm worrying for nothing.--[math show=f]startTM=[elapsedtime][/math] [writefile ./test.txt][loop start=1&end=5000000][index] [/loop][/writefile] [math][elapsedtime]-[startTM][/math] On 7/9/02 8:00 PM, Kenneth Grome mashed the following keys :>> On 7/9/02 6:16 PM, Alain Russell
wrote: >> >>> I would have thought anything you did with a 500 MB database would be slow >>> .. ? >> >> Doing simple searches will be fine. We may end up having to run SQL to do >> what we want... > > You don't need SQL to do a simple search that finds the top agents > when you dynamically create a new salesvolume.db every day > immediately after you upload the MLS data and perform your searches > in the new db. > > > Sincerely, > Kenneth Grome > > --------------------------------------------------- > WebDNA Professional Training and Development Center > 175 J. Llorente Street +63 (32) 255-6921 > Cebu City, Cebu 6000 kengrome@webdna.net > Philippines http://www.webdna.net > --------------------------------------------------- > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
You're right, but in my experience to date, doing a simple append to like a 5 or 10 meg database will completely lockup Webcat for several minutes.So I've always avoided doing massive writes/replaces/appends like plague.If I could do a single search in SQL, and not lockup the primary web server doing it, that would be good.On Mac OS, spawn has never worked right, and while I'm planning on implementing this on OSX on a DP 533 or maybe even a DP xserve, I'm a little reluctant to try and write out that much data.--a little while later--Well, I just did a test, (on my powerbook mind you) and webcat wrote a 500k line file to 37 MB file in 1986 ticks. So maybe I'm worrying for nothing.--[math show=f]startTM=[elapsedtime][/math] [writefile ./test.txt][loop start=1&end=5000000][index] [/loop][/writefile] [math][elapsedtime]-[startTM][/math] On 7/9/02 8:00 PM, Kenneth Grome mashed the following keys :>> On 7/9/02 6:16 PM, Alain Russell wrote: >> >>> I would have thought anything you did with a 500 MB database would be slow >>> .. ? >> >> Doing simple searches will be fine. We may end up having to run SQL to do >> what we want... > > You don't need SQL to do a simple search that finds the top agents > when you dynamically create a new salesvolume.db every day > immediately after you upload the MLS data and perform your searches > in the new db. > > > Sincerely, > Kenneth Grome > > --------------------------------------------------- > WebDNA Professional Training and Development Center > 175 J. Llorente Street +63 (32) 255-6921 > Cebu City, Cebu 6000 kengrome@webdna.net > Philippines http://www.webdna.net > --------------------------------------------------- > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Aaron Lynch
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:
[LOOKUP] (1997)
Rollovers (1999)
Online reference (1997)
Further on formula.db failure to calculate shipCost (1997)
WCS Newbie question (1997)
NT or Mac (1997)
Reversing [ipaddress] normalization (1998)
Non Standard Product Display Layout (2000)
Generating and appending SKU to a db automatically (1998)
[ShowNext] feature in 2.0 (1997)
SET (1998)
Most Efficiant Way to do restricted Areas (1997)
Quick ShowIf question (1997)
auto-stripping of spaces (1997)
Secure server question (1997)
Hiding HTML and page breaks (1997)
Physical Security for WebCatalog Directories (1997)
Authenticate (1997)
Add to Cart & List of Products (1997)
Bug? (1997)