Re: Here we go again...
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66672
interpreted = N
texte = > Performance really comes down to how things> are structured. Code for scale and I don't see > any limitations with webdna.This assumes that it's practical or possible to "code for scale" in webdna all the time. But this is not always possible ...In the example I just gave a day or so ago it was practically impossible to "code for scale". Maybe you have not personally experienced this type of situation and that's why you don't see any limitations in webdna, but I have seen this situation -- more than once -- and it's not a fun situation to be in when you love webdna and want to use it for everything.In my recent example the data came from another source -- a source that uses FMPro as its original database. This is not some little company either, it is the leader in its industry.To make this data work in webdna means exporting it as tab-delimited text files, then using those resulting flat files -- and whatever coding techniques are available in webdna -- to get the search results required by the client. The problem is that the data is not structured for efficient use of webdna (by any stretch of the imagination) so webdna is pathetically slow when doing the kind of searches the client requires. As the web developer on this project, I did not have authorization to go in and reformat these multi-megabyte data files in order to "make them work" with webdna. This would have taken 10-20 times as long as trying another software. Besides, I was not convinced that webdna would perform as well as MySQL even if we did go in and reformat the databases to optimize them for webdna -- because I've seen slow performance in similar situations before when using webdna on such large data sets (without nested searches) -- and I didn't want the client to have to pay for all that labor only to find that webdna still couldn't handle the task.So instead of "coding or scale" which would have meant restructuring the database files that we exported from FMPro, I had my put everything we had into PHP/MySQL. It took him less than 10 hours to do this (at $1.20 an hour for his labor) ... so for about twelve bucks I was able to see that PHP/MySQL was far superior to webdna in this situation. This saved the client hundreds if not thousands of dollars over using a webdna solution.The bottom line here is that webdna has serious limitations that make it a poor substitute for MySQL in certain situations. In these situations MySQL and other truly relational data systems are far better suited to the tasks at hand.Sincerely, Kenneth Grome owner@kengrome.comkengrome@gmail.comwww.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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
> Performance really comes down to how things> are structured. Code for scale and I don't see > any limitations with webdna.This assumes that it's practical or possible to "code for scale" in webdna all the time. But this is not always possible ...In the example I just gave a day or so ago it was practically impossible to "code for scale". Maybe you have not personally experienced this type of situation and that's why you don't see any limitations in webdna, but I have seen this situation -- more than once -- and it's not a fun situation to be in when you love webdna and want to use it for everything.In my recent example the data came from another source -- a source that uses FMPro as its original database. This is not some little company either, it is the leader in its industry.To make this data work in webdna means exporting it as tab-delimited text files, then using those resulting flat files -- and whatever coding techniques are available in webdna -- to get the search results required by the client. The problem is that the data is not structured for efficient use of webdna (by any stretch of the imagination) so webdna is pathetically slow when doing the kind of searches the client requires. As the web developer on this project, I did not have authorization to go in and reformat these multi-megabyte data files in order to "make them work" with webdna. This would have taken 10-20 times as long as trying another software. Besides, I was not convinced that webdna would perform as well as MySQL even if we did go in and reformat the databases to optimize them for webdna -- because I've seen slow performance in similar situations before when using webdna on such large data sets (without nested searches) -- and I didn't want the client to have to pay for all that labor only to find that webdna still couldn't handle the task.So instead of "coding or scale" which would have meant restructuring the database files that we exported from FMPro, I had my put everything we had into PHP/MySQL. It took him less than 10 hours to do this (at $1.20 an hour for his labor) ... so for about twelve bucks I was able to see that PHP/MySQL was far superior to webdna in this situation. This saved the client hundreds if not thousands of dollars over using a webdna solution.The bottom line here is that webdna has serious limitations that make it a poor substitute for MySQL in certain situations. In these situations MySQL and other truly relational data systems are far better suited to the tasks at hand.Sincerely, Kenneth Grome owner@kengrome.comkengrome@gmail.comwww.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 Web Archive of this list is at: http://webdna.smithmicro.com/
Kenneth Grome
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:
Forms & Tables (1998)
Search design (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
[shownext] and sort (1998)
Question (1997)
Email truncation in Eudora. (1998)
process SSI (1998)
Image editing in browser (2005)
Not reading code (1997)
Using [Include] Context (1999)
Interfacing WebMerchant to www.fedex.com (1997)
Multiple Ad databases? (1997)
Cart Template (1997)
WebCatalog sales (1997)
WebCatalog on Windows 98 (2000)
Authentication issue (2006)
setting taxable to true (1997)
WebCatalog Technical Reference (1997)
New Problem (1997)
Webten + Webcat running smooth (1998)