Re: Here we go again...WebDNA - SQL- Clustering
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66742
interpreted = N
texte = Oh boy... I guess I did stir quite a bit here with SQL and flat file. I start this = all. There is nothing wrong with flat file until you find SQL can do = something easier or faster on certain things. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Donovan Brooke Sent: Tuesday, April 04, 2006 11:15 AM To: WebDNA Talk Subject: Re: Here we go again...WebDNA - SQL- Clustering Bess Ho wrote: > Thanks Nitai for taking the time to explain different=20 > scenarios to WebDNA developers. Some have to experience the > SQL to understand the advantages other flat file. O.K., I said I was getting back to work. But, since I'm waiting on password and since Bess was one of the main reasons I got passionate about this thread, I have put together a little list of all the mis-conceptions that Bess has stated (from latest to last): > Again flat file has limitation on performance on server Bess, what you fail to mention is that a flat file database structure can function just perfectly (with no limitations) for the majority of needs out there. Sure, it depends on what you are targeting. WebDNA does eCommerce, but it does LAN stuff and other functions as well. These blanket statements are just wrong. > Flat file makes it too much hassle to do any business intelligences, data mining or even reporting. It is not scalable for enterprise = application. Just flat out wrong. You are newbie to this list and to say webdna can't do reporting etc.. is just silly. > Thanks Kenneth. Thanks for clarifying the myth. Kenneth is a Myth... O.K., I just had to put that one in there for = enternainment purposes. > I think it is important for developers to understand the facts. = WebDNA is not "relational" database Again, that's just plain wrong. It doesn't take a skilled developer to = do this. [search db=3D...&blah] [founditems][lookup = db=3Danother&value=3DID_OF_SECOND_DB_STORED_IN_FIRST_DATABASE&Blah]etc...= [/founditems] [/search] > Tab-delimited text files... It really makes many non-webdna = developers "wonder" You make it sound like a text table is not ever used on the web. Think = Again! > WebDNA is using flat file for storing data. It is not a relationship = database like MySQL. - already addressed > Also once your flat file grow beyond roughly 2 GB (check with Network = Admin to verify the size), This is a limit set by the OS and hard drive formatting... not webdna. > you can't run data very well. The go-around solution is to break down = WebDNA database into smaller > chunks for faster performance. Its not a "go-around" its just good programming, and in fact, is called = a relational framework. > You really need Relationship Database for scaleable application. Sigh. No you don't. You *may* need it.. but not always. It depends on = what the client is doing. > Everyone is rushing to develop something else with open source and = faster deployment [speaking about webdna]. I'm not. Donovan --password arrived. :-) --=20 = =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us = =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do ------------------------------------------------------------- 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:
Oh boy... I guess I did stir quite a bit here with SQL and flat file. I start this = all. There is nothing wrong with flat file until you find SQL can do = something easier or faster on certain things. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Donovan Brooke Sent: Tuesday, April 04, 2006 11:15 AM To: WebDNA Talk Subject: Re: Here we go again...WebDNA - SQL- Clustering Bess Ho wrote: > Thanks Nitai for taking the time to explain different=20 > scenarios to WebDNA developers. Some have to experience the > SQL to understand the advantages other flat file. O.K., I said I was getting back to work. But, since I'm waiting on password and since Bess was one of the main reasons I got passionate about this thread, I have put together a little list of all the mis-conceptions that Bess has stated (from latest to last): > Again flat file has limitation on performance on server Bess, what you fail to mention is that a flat file database structure can function just perfectly (with no limitations) for the majority of needs out there. Sure, it depends on what you are targeting. WebDNA does eCommerce, but it does LAN stuff and other functions as well. These blanket statements are just wrong. > Flat file makes it too much hassle to do any business intelligences, data mining or even reporting. It is not scalable for enterprise = application. Just flat out wrong. You are newbie to this list and to say webdna can't do reporting etc.. is just silly. > Thanks Kenneth. Thanks for clarifying the myth. Kenneth is a Myth... O.K., I just had to put that one in there for = enternainment purposes. > I think it is important for developers to understand the facts. = WebDNA is not "relational" database Again, that's just plain wrong. It doesn't take a skilled developer to = do this. [search db=3D...&blah] [founditems][lookup = db=3Danother&value=3DID_OF_SECOND_DB_STORED_IN_FIRST_DATABASE&Blah]etc...= [/founditems] [/search] > Tab-delimited text files... It really makes many non-webdna = developers "wonder" You make it sound like a text table is not ever used on the web. Think = Again! > WebDNA is using flat file for storing data. It is not a relationship = database like MySQL. - already addressed > Also once your flat file grow beyond roughly 2 GB (check with Network = Admin to verify the size), This is a limit set by the OS and hard drive formatting... not webdna. > you can't run data very well. The go-around solution is to break down = WebDNA database into smaller > chunks for faster performance. Its not a "go-around" its just good programming, and in fact, is called = a relational framework. > You really need Relationship Database for scaleable application. Sigh. No you don't. You *may* need it.. but not always. It depends on = what the client is doing. > Everyone is rushing to develop something else with open source and = faster deployment [speaking about webdna]. I'm not. Donovan --password arrived. :-) --=20 = =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us = =3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3Do=3D= o=3Do=3Do=3Do=3Do=3Do=3Do ------------------------------------------------------------- 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:
Multiple Merchant Accounts? (1997)
Search Context Strips URL chrs.? (1999)
merchant account recommendations? (2002)
[WebDNA] Problems with WebCatalogCtl command (2009)
chicken / egg::purchase / setheader (2002)
Hyperboard/bulletin board available (1998)
off topic - dna snipets (1997)
[OT] Linux -> Winderz (2005)
rename a file (1997)
Emailer port change (1997)
Counting LineItems (2000)
How to break a search ... (2002)
emailer (1997)
multi-paragraph fields (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
2nd WebCatalog2 Feature Request (1996)
groups and [ShowNext] (1997)
WebCat2.0 [format thousands .0f] no go (1997)
WebDelivery downloads alias, not original ? (1997)
emailer (1997)