Re: Here we go again...WebDNA - SQL- Clustering
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66737
interpreted = N
texte = Bess Ho wrote: > Thanks Nitai for taking the time to explain different > 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=...&blah] [founditems][lookup db=another&value=ID_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. :-) -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o 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 =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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:
Bess Ho wrote: > Thanks Nitai for taking the time to explain different > 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=...&blah] [founditems][lookup db=another&value=ID_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. :-) -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o 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 =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/
Donovan Brooke
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:
getchars broken? (1997)
WebCat2 as a chat server? (1997)
Bug Report, maybe (1997)
F2 to F3 rocky transition (1997)
Order not created error (1997)
question: webmerchant connection (1997)
Webmerchant + Hubby (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
The List is Changing (1997)
time and welcome (1999)
[WebDNA] Writefile size limit? (2011)
Introduction/Tutorial/QuickStart (1997)
CommandSecurity? (1997)
WebCat constantly restarting (2001)
[WebDNA] Triggers not working (2011)
Converting order file to database (1998)
AddLineItem Problem (1997)
Help on how to store calculated value (2002)
I am dumb. No see [variable] (2003)
Secure Server (1997)