Re: Here we go again...WebDNA - SQL- Clustering

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66713
interpreted = N
texte = Alex McCombie wrote: > Lol the funny thing everyone is so passionately debating the WebDNA tables > VS. SQL like they are sworn enemies. > > Let me help (I hope) -- They work together. VERY WELL. > > I spent years on WebDNA. Besides Bob and Ken and a few others I would wager > that have been on here as long as anyone. Long long long time :-) > > Truth is I still use DNA flat files. And I also use the table tag to > temporarily store MSSQL data returns for recursive (RAM) searching. > > I use both. In the same page of code. And again, it works very very well :-) > > Why MSSQL? Well, there are lots of reasons. A few of them that come to mind > are > > Transactional Logging. There have been times when we needed to go to backups > and then rebuild all the data structure through time. Rare but it has > happened. > > Multiple points of entry and exit. I use it in an environment where there > are asp pages, php pages, Access Apps, and TPL pages and they all need to > manipulate the same data in REAL TIME. And no the data dumping, > import/exporting of data in bulk to be "semi-realtime" is not acceptable. > With DNA/MSSQL this is a snap. How much extra code is needed for this? Um, > none. > > True data warehousing as well as multiple front end servers hitting the same > data. Across the network or across the web it all doable. Again in real > time. > > > Why MSSQL instead of MySQL? Well mostly because its a MS shop. Gotta work > within the system. Frankly, if the tests all hold up it seems that the > syntax is identical if you hit MySQL with ODBC instead of the Native DNA > MySQL tags. Why is this so important? Well when your sitting there debugging > and need to hit the SQL server with your search in Query Analyzer its a lot > better when all you have to do is copy and paste your SQL tag which would > not work with the native tags (best I can tell). > > Huge data sets DO suffer from the undefined nature of WebDNA tables. Anyone > doing large text searches on the two can attest. It also suffers from no > field definition when doing date searches and math. > > Lets not forget about the join context instead of recursive searching! The > ability to group across multiple tables with doing recursive searching in a > FI loop will start making a HUGE difference on large data sets. > > > Don't get me wrong guys. I use WebDNA every single day for some pretty > in-depth tools (one rolling out to schools across NY soon). For the most > part now, we use DNA as the front end to MSSQL. We still do flat files > resident in DNA, and also will be doing MySQL (through ODBC soon). So I > don't see it as a either or. Integrating SQL tags was a critical maneuver on > the part of SMSI... If only it had come with marketing ;-) Alex, you, Ken, John H, John P, Brian and many others were at, if not near, "guru" status when I was most definately "diapers" status. Many of you helped me through the growing pains. I'm with you on just *about* every point on this. Businesses more and more want there core systems to work with their web systems. The new SQL tags help greatly with communication. It's very existance helps validate webdna to a larger audience. There have been a lot of changes with the product since I first got started. SMSI really has done a lot. I've noticed many transparent changes that have helped the performance of webdna... not to mention the obvious new tags. I remember the sluggish machines, and the sluggish simple searches. Those days are gone. What I know is that efficient code can go a long way on the current webdna versions. But, I'm with you... Use all the tools as needed. A question: "transactional logging"... how does this benefit over a good backup schematic? Donovan -- =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:

    
  1. Re: Here we go again...WebDNA - SQL- Clustering ( Kenneth Grome 2006)
  2. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  3. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  4. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  5. Re: Here we go again...WebDNA - SQL- Clustering ( "Bess Ho" 2006)
  6. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  7. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  8. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  9. Re: Here we go again...WebDNA - SQL- Clustering ( Adam O'Connor 2006)
  10. Re: Here we go again...WebDNA - SQL- Clustering ( nitai@computeroil.com 2006)
  11. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  12. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  13. Re: Here we go again...WebDNA - SQL- Clustering ( nitai@computeroil.com 2006)
  14. Re: Here we go again...WebDNA - SQL- Clustering ( Donovan Brooke 2006)
  15. Re: Here we go again...WebDNA - SQL- Clustering ( Alex McCombie 2006)
  16. Re: Here we go again...WebDNA - SQL- Clustering ( Bob Minor 2006)
  17. Re: Here we go again...WebDNA - SQL- Clustering ( Stuart Tremain 2006)
  18. Re: Here we go again...WebDNA - SQL- Clustering ( Adam O'Connor 2006)
Alex McCombie wrote: > Lol the funny thing everyone is so passionately debating the WebDNA tables > VS. SQL like they are sworn enemies. > > Let me help (I hope) -- They work together. VERY WELL. > > I spent years on WebDNA. Besides Bob and Ken and a few others I would wager > that have been on here as long as anyone. Long long long time :-) > > Truth is I still use DNA flat files. And I also use the table tag to > temporarily store MSSQL data returns for recursive (RAM) searching. > > I use both. In the same page of code. And again, it works very very well :-) > > Why MSSQL? Well, there are lots of reasons. A few of them that come to mind > are > > Transactional Logging. There have been times when we needed to go to backups > and then rebuild all the data structure through time. Rare but it has > happened. > > Multiple points of entry and exit. I use it in an environment where there > are asp pages, php pages, Access Apps, and TPL pages and they all need to > manipulate the same data in REAL TIME. And no the data dumping, > import/exporting of data in bulk to be "semi-realtime" is not acceptable. > With DNA/MSSQL this is a snap. How much extra code is needed for this? Um, > none. > > True data warehousing as well as multiple front end servers hitting the same > data. Across the network or across the web it all doable. Again in real > time. > > > Why MSSQL instead of MySQL? Well mostly because its a MS shop. Gotta work > within the system. Frankly, if the tests all hold up it seems that the > syntax is identical if you hit MySQL with ODBC instead of the Native DNA > MySQL tags. Why is this so important? Well when your sitting there debugging > and need to hit the SQL server with your search in Query Analyzer its a lot > better when all you have to do is copy and paste your SQL tag which would > not work with the native tags (best I can tell). > > Huge data sets DO suffer from the undefined nature of WebDNA tables. Anyone > doing large text searches on the two can attest. It also suffers from no > field definition when doing date searches and math. > > Lets not forget about the join context instead of recursive searching! The > ability to group across multiple tables with doing recursive searching in a > FI loop will start making a HUGE difference on large data sets. > > > Don't get me wrong guys. I use WebDNA every single day for some pretty > in-depth tools (one rolling out to schools across NY soon). For the most > part now, we use DNA as the front end to MSSQL. We still do flat files > resident in DNA, and also will be doing MySQL (through ODBC soon). So I > don't see it as a either or. Integrating SQL tags was a critical maneuver on > the part of SMSI... If only it had come with marketing ;-) Alex, you, Ken, John H, John P, Brian and many others were at, if not near, "guru" status when I was most definately "diapers" status. Many of you helped me through the growing pains. I'm with you on just *about* every point on this. Businesses more and more want there core systems to work with their web systems. The new SQL tags help greatly with communication. It's very existance helps validate webdna to a larger audience. There have been a lot of changes with the product since I first got started. SMSI really has done a lot. I've noticed many transparent changes that have helped the performance of webdna... not to mention the obvious new tags. I remember the sluggish machines, and the sluggish simple searches. Those days are gone. What I know is that efficient code can go a long way on the current webdna versions. But, I'm with you... Use all the tools as needed. A question: "transactional logging"... how does this benefit over a good backup schematic? Donovan -- =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:

[LOOKUP] (1997) WebCat2 several catalogs? (1997) WebMerchant 1.6 and https (1997) New Command prefs ... (1997) price formula (1999) unable to launch acgi in WebCat (1997) Templates for Customer Database? (1997) Upgrading old WebCat Database Files (1997) Multiple Newcarts (1996) Online reference (1997) 2.0 Info (1997) suffix mapping for NT? (1997) Web Delivery Page concept (1997) Sending E-mail (1997) shipcost (1997) Use of Back and Reload Buttons on ShoppingCart page? (1997) Re1000002: Setting up shop (1997) [SearchString] problem with [search] context (1997) WebCat2b12plugin - [search] is broken ... not! (1997) help needed w/ search params (1998)