Re: Me know logical no need
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41333
interpreted = N
texte = We recently did a job like this with a fortnightly update of 20,000 productsvia a tab delimited file.The file was junk so we just asked them to change the format so it wouldwork better and we wouldn't have to code so much.Thatıs the good thing about kiwis, we think outside of the square. Don'tspend years writing thousands of lines of code to manipulate crap data. Getthe client to fix the data and write bugger all code.Thinking about it - if they have a 500mb database - they must have somefairly serious hardware powering it. Get them to sort it out for you.On 10/7/02 4:09 PM, Aaron Lynch
wrote:> No you aren;t missing anything.> > But keep in mind that over night, I have to run triggers that download the> data, fix the data from the stupid MLS (things like space padding in All of> the fields, year as '2002.000' #of fireplaces in thousandths '2.000'> > (did I mention they are stupid? Anybody know what the hell .400th of a> fireplace is? A freakin brick maybe?) -don;t get me started on how dumb> this database is and the hoops I gotta go through just to use it!)> > AND I have this dang tree farm site that runs triggers then too. ;>> > > > > > > On 7/9/02 8:55 PM, Glenn Busbin mashed the following keys :> >>> 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.>> >> Aaron,>> Since the db is updated once per day, the searches need only be done once per>> day. The reports can be written to static files once, not every time one of>> the 15k silver tongues looks at the site. The data displayed will be as>> current as the info you received earlier in the day.>> >> Or am I missing something in how this thing is being used?>> >> Glenn>> >> ------------------------------------------------------------->> 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/-- Andrew SimpsonWeb DevelopmentBlackpepper Interactive LtdPO Box 99805Newmarket4 Clayton StreetNewmarketAucklandPh: +64 9 520-6281Mob: 0272733270Fax: +64 9 524-1849http://www.blackpepper.co.nz-------------------------------------------------------------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:
We recently did a job like this with a fortnightly update of 20,000 productsvia a tab delimited file.The file was junk so we just asked them to change the format so it wouldwork better and we wouldn't have to code so much.Thatıs the good thing about kiwis, we think outside of the square. Don'tspend years writing thousands of lines of code to manipulate crap data. Getthe client to fix the data and write bugger all code.Thinking about it - if they have a 500mb database - they must have somefairly serious hardware powering it. Get them to sort it out for you.On 10/7/02 4:09 PM, Aaron Lynch wrote:> No you aren;t missing anything.> > But keep in mind that over night, I have to run triggers that download the> data, fix the data from the stupid MLS (things like space padding in All of> the fields, year as '2002.000' #of fireplaces in thousandths '2.000'> > (did I mention they are stupid? Anybody know what the hell .400th of a> fireplace is? A freakin brick maybe?) -don;t get me started on how dumb> this database is and the hoops I gotta go through just to use it!)> > AND I have this dang tree farm site that runs triggers then too. ;>> > > > > > > On 7/9/02 8:55 PM, Glenn Busbin mashed the following keys :> >>> 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.>> >> Aaron,>> Since the db is updated once per day, the searches need only be done once per>> day. The reports can be written to static files once, not every time one of>> the 15k silver tongues looks at the site. The data displayed will be as>> current as the info you received earlier in the day.>> >> Or am I missing something in how this thing is being used?>> >> Glenn>> >> ------------------------------------------------------------->> 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/-- Andrew SimpsonWeb DevelopmentBlackpepper Interactive LtdPO Box 99805Newmarket4 Clayton StreetNewmarketAucklandPh: +64 9 520-6281Mob: 0272733270Fax: +64 9 524-1849http://www.blackpepper.co.nz-------------------------------------------------------------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/
Andrew Simpson
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:
Problem with encrypted cookies (2000)
Stop the madness. (1997)
Range search (2003)
supressing math results (1997)
New Plug-in and Type 11 errors (1997)
Silly little OT question (2004)
[WebDNA] postfix and dna (2011)
Uploading very large image files (2003)
[random] only for 1-100??? (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Modifying order output (1997)
WebCatalog for Postcards ? (1997)
emailer (1997)
DON'T use old cart file! (1997)
[WebDNA] [OT] Need to add second SSL host - what are my options? (2010)
Math (1997)
Webstar 1.3.1 PPC (1997)
Possible Bug in 2.0b15.acgi (1997)
TCPConnect and SSL servers (2001)
Location of Browser Info.txt file (1997)