Re: Here we go again...
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66689
interpreted = N
texte = Can you use WebDNA database outside WebDNA folder?Are you required to use WebDNA to interect with WebDNA database?How do you see the database relationship?Bess-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfPat McCormickSent: Saturday, April 01, 2006 6:43 AMTo: WebDNA TalkSubject: Re: Here we go again...Actually WebDNA doesn't use a flat file. That is the case for the =20older Typhoon version, but WebDNA, simply because it can have =20multiple databases open, is no longer a flat file system.The difference is that WebDNA doesn't formalize the structure of a db =20in any way. You are responsible for define a sku or key field and =20there are some nice tools to assist the process, like [cart]. =20Comparing that with SQL or Access, those products get more antsy =20about key fields, and field formats in general. They also enforce the =20idea of a database consisting of a collection of tables, which is =20also confusing nonsense.The purpose for products like Oracle, SQL and other "databases" is to =20encrypt your text so that you need to buy their products to see your =20text. Web-DNA is the un-database database. Create your own =20relationships. All key fields are optional. Structure your project =20any way you want, even using virtual databases ([table]), and to make =20it even better, keep all the data in plain text so you can x-ray the =20files at any time using any text tool. Ya gotta love that!On Mar 31, 2006, at 2:12 PM, Bess Ho wrote:> WebDNA is using flat file for storing data. It is not a =20> relationship database like MySQL. Also once your flat file grow =20> beyond roughly 2 GB (check with Network Admin to verify the size), =20> you can't run data very well. The go-around solution is to break =20> down WebDNA database into smaller chunks for faster performance. =20> You really need Relationship Database for scaleable application.>> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Kenneth Grome> Sent: Friday, March 31, 2006 4:55 AM> To: WebDNA Talk> Subject: Re: Here we go again...>>> 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, =20> so he hired me to debug and fix them. His code was fine but the =20> database files were not configured to optimize webdna's =20> performance, so I could only recommend two options: (1) =20> reconfigure the databases (not a good solution because updated data =20> files came from another source frequently) ... or (2) switch to =20> MySQL and give that a try ...>> I really didn't know if MySQL could handle the task any faster than =20> webdna and I told him this, but he went for it anyways. He said =20> webdna hosting cost too much anyways, and since he wasn't committed =20> to using it on his server anyways (although he enjoyed personally =20> mocking up web sites because it's east for a non-programmer to use) =20> he decided to go with PHP and MySQL.>> The moment we switched his search times dropped from about 10 =20> seconds to less than two seconds. I think the reason is two-fold: =20> (1) he had database files that were too large for webdna to RAM-=20> cache efficiently, and (2) we were doing nested searches, and =20> webdna is pretty slow sometimes when using nested searches, =20> especially with large db files.>> The bottom line is that he "outgrew" webdna for use on his server, =20> and now he's happy again with a faster free solution. I think this =20> type of situation is going to become more and more common as webdna =20> continues to be less and less aggressively developed, supported and =20> marketed.>> Sincerely,> Kenneth Grome>> owner@kengrome.com> kengrome@gmail.com> www.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.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://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Can you use WebDNA database outside WebDNA folder?Are you required to use WebDNA to interect with WebDNA database?How do you see the database relationship?Bess-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfPat McCormickSent: Saturday, April 01, 2006 6:43 AMTo: WebDNA TalkSubject: Re: Here we go again...Actually WebDNA doesn't use a flat file. That is the case for the =20older Typhoon version, but WebDNA, simply because it can have =20multiple databases open, is no longer a flat file system.The difference is that WebDNA doesn't formalize the structure of a db =20in any way. You are responsible for define a sku or key field and =20there are some nice tools to assist the process, like [cart]. =20Comparing that with SQL or Access, those products get more antsy =20about key fields, and field formats in general. They also enforce the =20idea of a database consisting of a collection of tables, which is =20also confusing nonsense.The purpose for products like Oracle, SQL and other "databases" is to =20encrypt your text so that you need to buy their products to see your =20text. Web-DNA is the un-database database. Create your own =20relationships. All key fields are optional. Structure your project =20any way you want, even using virtual databases ([table]), and to make =20it even better, keep all the data in plain text so you can x-ray the =20files at any time using any text tool. Ya gotta love that!On Mar 31, 2006, at 2:12 PM, Bess Ho wrote:> WebDNA is using flat file for storing data. It is not a =20> relationship database like MySQL. Also once your flat file grow =20> beyond roughly 2 GB (check with Network Admin to verify the size), =20> you can't run data very well. The go-around solution is to break =20> down WebDNA database into smaller chunks for faster performance. =20> You really need Relationship Database for scaleable application.>> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Kenneth Grome> Sent: Friday, March 31, 2006 4:55 AM> To: WebDNA Talk> Subject: Re: Here we go again...>>> 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, =20> so he hired me to debug and fix them. His code was fine but the =20> database files were not configured to optimize webdna's =20> performance, so I could only recommend two options: (1) =20> reconfigure the databases (not a good solution because updated data =20> files came from another source frequently) ... or (2) switch to =20> MySQL and give that a try ...>> I really didn't know if MySQL could handle the task any faster than =20> webdna and I told him this, but he went for it anyways. He said =20> webdna hosting cost too much anyways, and since he wasn't committed =20> to using it on his server anyways (although he enjoyed personally =20> mocking up web sites because it's east for a non-programmer to use) =20> he decided to go with PHP and MySQL.>> The moment we switched his search times dropped from about 10 =20> seconds to less than two seconds. I think the reason is two-fold: =20> (1) he had database files that were too large for webdna to RAM-=20> cache efficiently, and (2) we were doing nested searches, and =20> webdna is pretty slow sometimes when using nested searches, =20> especially with large db files.>> The bottom line is that he "outgrew" webdna for use on his server, =20> and now he's happy again with a faster free solution. I think this =20> type of situation is going to become more and more common as webdna =20> continues to be less and less aggressively developed, supported and =20> marketed.>> Sincerely,> Kenneth Grome>> owner@kengrome.com> kengrome@gmail.com> www.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.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://webdna.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://webdna.smithmicro.com/
"Bess Ho"
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:
Webcat XML/XSLT Performance vs. static Html (2006)
sendmail error (1997)
WebCatalog 2.0 b 15 mac (1997)
Roundup function? (1997)
Typhoon Rev. and PCS store problems (1999)
exclusive db lock with webcat-3 ? (2000)
RAM problems, [appendfile] problems (1998)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
WebDNA Codes in Secure Mode (1997)
Claris HomePage messes up the code (1997)
Pull Down Search (2000)
Quotation Marks in Database (1998)
WebCat2b15MacPlugin - showing [math] (1997)
Popup Menu Options (1998)
Setting up shop (1997)
Smith Micro supports our users in so many ways... We are here to (1999)
Initiating NewCart (1997)
Location of Browser Info.txt file (1997)
WebTen? (1997)
Chatroom (2000)