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:
shipping confusion (2000)
PIXO support (1997)
RED QUESTION MARKS AGAIN (1999)
Re1000002: Setting up shop (1997)
SiteEdit NewFile.html ? (1997)
Cart # Starting at 1000 (2000)
ReadDateFormat bug in 3.0.1 (1998)
Replacing a Word (1999)
Separate server for jpg/gif files (1998)
Re2: frames & carts (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
[include ...] behavior (1997)
Separate SSL Server (1997)
searching multiple databases in single search (1997)
Setting up shop (1997)
Secure Server (1997)
unique ascending numbers (2003)
[WebDNA] Setting up a new server, hierarchy question (2014)
[WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (2009)
WCS Newbie question (1997)