Re: Here we go again...
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66636
interpreted = N
texte = On Fri, 31 Mar 2006 07:05:55 -0500, Terry Wilson wrote:> ... you never know when you'll be required to start doing something a > certain way; or at some point, an old solution just isn't good enough > or fast enough any longer ...Example:A client of mine preferred webdna but his searches were too slow, so he hired me to debug and fix them. His code was fine but the database files were not configured to optimize webdna's performance, so I could only recommend two options: (1) reconfigure the databases (not a good solution because updated data files came from another source frequently) ... or (2) switch to MySQL and give that a try ... I really didn't know if MySQL could handle the task any faster than webdna and I told him this, but he went for it anyways. He said webdna hosting cost too much anyways, and since he wasn't committed to using it on his server anyways (although he enjoyed personally mocking up web sites because it's east for a non-programmer to use) he decided to go with PHP and MySQL.The moment we switched his search times dropped from about 10 seconds to less than two seconds. I think the reason is two-fold: (1) he had database files that were too large for webdna to RAM-cache efficiently, and (2) we were doing nested searches, and webdna is pretty slow sometimes when using nested searches, especially with large db files.The bottom line is that he "outgrew" webdna for use on his server, and now he's happy again with a faster free solution. I think this type of situation is going to become more and more common as webdna continues to be less and less aggressively developed, supported and marketed.Sincerely, Kenneth Grome owner@kengrome.comkengrome@gmail.comwww.kengrome.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On Fri, 31 Mar 2006 07:05:55 -0500, Terry Wilson wrote:> ... you never know when you'll be required to start doing something a > certain way; or at some point, an old solution just isn't good enough > or fast enough any longer ...Example:A client of mine preferred webdna but his searches were too slow, so he hired me to debug and fix them. His code was fine but the database files were not configured to optimize webdna's performance, so I could only recommend two options: (1) reconfigure the databases (not a good solution because updated data files came from another source frequently) ... or (2) switch to MySQL and give that a try ... I really didn't know if MySQL could handle the task any faster than webdna and I told him this, but he went for it anyways. He said webdna hosting cost too much anyways, and since he wasn't committed to using it on his server anyways (although he enjoyed personally mocking up web sites because it's east for a non-programmer to use) he decided to go with PHP and MySQL.The moment we switched his search times dropped from about 10 seconds to less than two seconds. I think the reason is two-fold: (1) he had database files that were too large for webdna to RAM-cache efficiently, and (2) we were doing nested searches, and webdna is pretty slow sometimes when using nested searches, especially with large db files.The bottom line is that he "outgrew" webdna for use on his server, and now he's happy again with a faster free solution. I think this type of situation is going to become more and more common as webdna continues to be less and less aggressively developed, supported and marketed.Sincerely, Kenneth Grome owner@kengrome.comkengrome@gmail.comwww.kengrome.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://webdna.smithmicro.com/
Kenneth Grome
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:
Sku numbers (1997)
Sorting by date (1997)
Netiquette: how to get the most out of this list (1999)
security (https) w webcat (1999)
idear about how to get SMSI to speak. (2006)
re: Large databases in WebCat (1997)
[accountNum] and [math] (1997)
simple forum/bboard (2004)
[BULK] [WebDNA] [BULK] looking for the holy grail of hosting still (2013)
[WebDNA] Failed to aquire lock on database - Possible deadlock averted (2011)
Need Sample Template - just purchased (1997)
Browser Info.txt (1997)
Searching Relational Databases (2004)
Multiple fields on 1 input (1997)
Max Record length restated as maybe bug (1997)
More on the email templates (I like it) (1997)
find with exceptions (1997)
OT: Website Promotion (1998)
Rumpus/Typhoon modules included in Typhoon ... (1997)
Closing Databases (1998)