The only real scary thing is in case = one has a huge webdna code base that they need to translate to = PHP/SQL (e.g. due to size of data, like Alex said), but cannot = afford to translate = it.
-Govinda
On = 2013-08-01, at 12:49 PM, Alex McCombie wrote:
suzanne@specsimple.com> = wrote:
Thanks = Alex. Your post brings up an unrelated question...what is the = advantage of using MS SQL data in combination with WebDNA databases. = Is it faster?
= --Apple-Mail=_ED9346D2-44CD-4694-864B-E792137FDE8D--
Associated Messages, from the most recent to the oldest:
--Apple-Mail=_ED9346D2-44CD-4694-864B-E792137FDE8D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 I am still a Webdna-head too.. but just to add to the last point alex = made.. in case anyone ever needs to go to PHP.. and feels concerned = about that .. I say, no need. It's just another (albeit richer) set of = the same concepts you already know. Sure there is a learning curve.. = but once you start to get it.. and you will.. then you will realize you = were always well qualified. When I made that transition because of = clients that required it of me, after a couple months, then I ended up = in the same zone with PHP like I get with webdna. =20 The only real scary thing is in case one has a huge webdna code base = that they need to translate to PHP/SQL (e.g. due to size of data, like = Alex said), but cannot afford to translate it. -Govinda On 2013-08-01, at 12:49 PM, Alex McCombie wrote: > Actually it depends. > On most moderate sized data sets I would definitely get the speed = advantage to WebDNA. It's ram based after all. >=20 > But once we start talking millions of records or hundreds of thousands = of text blobs I find that SQL outperforms it when the data is designed = and indexed properly. Especially when you take into account specifically = designed Views in SQL which and eliminate great amounts of recursive = searching. >=20 > SQL isn't really about the speed comparison though. >=20 > SQL is an enterprise solution with robust backup and recovery options. = Restore to a particular moment is time is something that you would be = hard pressed to do with DNA. > Even more important than that is the connectivity of SQL via
ODBC to = so many sources. >=20 > For example. I have one system that is DNA fronted with a SQL backend. > There are also multiple users in the SQL database that are connecting = to the data via Excel, Filemaker and Sharepoint. All getting live data = that is in turn reflected on the web via WebDNA. >=20 > With DNA data, essentially you have the ability to connect the one = front end web application you build. And for most applications that = suffices. But with SQL back ended systems we have replicated servers = happening between physical locations. Multiple web products (different = servers) connecting to shared datasets. Applications like Filemaker and = Access connecting and working on the data, all in shared ways. >=20 > We will be moving to FMGO applications as well so iPads can have = client access to data. >=20 > All of this really doesn't have anything to do with WebDNA, but I = still think it's one of the best rapid development syntax's around for = web development.=20 >=20 > I will go to PHP kicking and screaming one day most likely but with = WebDNA connecting to SQL via
ODBC I have managed to delay that for 9 = years now :-)=20 >=20 > Still fighting the good fight :-) >=20 > HTH > Alex >=20 >=20 > On Aug 1, 2013, at 10:37 AM, Suzanne Swift
= wrote: >=20 >> Thanks Alex. Your post brings up an unrelated question...what is the = advantage of using MS SQL data in combination with WebDNA databases. Is = it faster? >>=20 >> Kind regards, >> Suzanne Swift >> President >> Spec Simple, Inc. >>=20 >> SpecSimple.com >> Where the World of Design Connects >>=20 >> Read about SpecSimple.com's Virtual Library in OfficeInsight >> See the Info Edge difference! >>=20 >>=20 >>=20 >> On Thu, Aug 1, 2013 at 10:31 AM, Alex McCombie = wrote: >> Webdna is used on some NYS Public school sites such as >> Oswego County Boces >> www.OswegoBoces.org >>=20 >> There are 2 other school districts in this county under development. >>=20 >>=20 >> It's also driving some private school sites such as >> Syracuse Center Of Excellence >> www.SyracuseCOE.org >>=20 >>=20 >> All the sites are developed using WebDNA and are data driven from MS = SQL data in combination with WebDNA databases acting as high performance = conduits for searching. >>=20 >> HTH >> Alex >>=20 >>=20 >>=20 >>=20 >> On Jul 31, 2013, at 2:02 PM, Suzanne Swift = wrote: >>=20 >>> Hi all, >>>=20 >>> I'm pitching a WebDNA project to the US State Department and they = want to know if DOD or any other US gov/military agency has ever used = WebDNA on a project. If there is precedence, the chances of getting = WebDNA approved for government use on a State Dept project is much = greater. =20 >>>=20 >>> Has anyone on the Talk List ever done a government project (DOD or = otherwise) with WebDNA? >>>=20 >>> Kind regards, >>> Suzanne Swift >>> President >>> Spec Simple, Inc. >>>=20 >>> SpecSimple.com >>> Where the World of Design Connects >>>=20 >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_ED9346D2-44CD-4694-864B-E792137FDE8D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 I am = still a Webdna-head too.. but just to add to the last point alex made.. = in case anyone ever needs to go to PHP.. and feels concerned about = that .. I say, no need. It's just another (albeit richer) set of = the same concepts you already know. Sure there is a learning = curve.. but once you start to get it.. and you will.. then you = will realize you were always well qualified. When I made that = transition because of clients that required it of me, after a couple = months, then I ended up in the same zone with PHP like I get with = webdna.
The only real scary thing is in case = one has a huge webdna code base that they need to translate to = PHP/SQL (e.g. due to size of data, like Alex said), but cannot = afford to translate = it.