Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103035
interpreted = N
texte = [snip] > > D., > > thanks for your reply. > The db's would be hit alot. The site is based on a kind of search > engine model. The searches would be narrowed by geography and then > further narrowed by topic, subtopic1, subtopic2, ... > > How are the [SQL] tags holding up in production for you guys using them? > > Any more feedback, and by anyone, would be really appreciated! ... I > am the responsible guy on this point and the truth is I have no > experience with monstrous db's like this. > > -Thanks > -G Don't use the [sql] tag, use the newer ([sqlconnect] etc) tags/contexts. (we should probably deprecate the [sql] tag and change it to [odbc] or something more appropriate.. because that is what it is and it is confusing. The new MySQL tags/contexts work just fine in our tests so far. This is an area we have started to look into more deeply. We haven't tested large databases yet, but joins and other (slightly complicated) MySQL queries have proved to work great and as expected. It is required to learn about MySQL of course when using these newer contexts. We will get into even deeper testing of these contexts in the near future, but from what I've seen so far, I'm not fearful of recommending it's use. Donovan -- Donovan Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  2. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  3. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  4. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  5. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Palle Bo Nielsen 2009)
  6. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  7. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA (Donovan Brooke 2009)
  8. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  9. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 2009)
  10. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  11. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA (Donovan Brooke 2009)
  12. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Patrick McCormick 2009)
  13. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  14. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA (Donovan Brooke 2009)
  15. [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
[snip] > > D., > > thanks for your reply. > The db's would be hit alot. The site is based on a kind of search > engine model. The searches would be narrowed by geography and then > further narrowed by topic, subtopic1, subtopic2, ... > > How are the [SQL] tags holding up in production for you guys using them? > > Any more feedback, and by anyone, would be really appreciated! ... I > am the responsible guy on this point and the truth is I have no > experience with monstrous db's like this. > > -Thanks > -G Don't use the [SQL] tag, use the newer ([SQLconnect] etc) tags/contexts. (we should probably deprecate the [SQL] tag and change it to [ODBC] or something more appropriate.. because that is what it is and it is confusing. The new MySQL tags/contexts work just fine in our tests so far. This is an area we have started to look into more deeply. We haven't tested large databases yet, but joins and other (slightly complicated) MySQL queries have proved to work great and as expected. It is required to learn about MySQL of course when using these newer contexts. We will get into even deeper testing of these contexts in the near future, but from what I've seen so far, I'm not fearful of recommending it's use. Donovan -- Donovan Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** 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:

authorizenet and netscape (2002) Why is deleting so slow? (2002) QuantityPrice computed? (1998) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) SiteGuard Admin Feature ? (1997) Sendmail truncation in Eudora Clients (1998) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) WebCat2b13 Command Reference Doc error (1997) Format of Required fields error message (1997) EmailProblem vs EmailComplete (2000) Adding Shipping Costs based on percent of subtotal (1997) webdelivery.html and webna (1997) [WebDNA] SMTP sendmail error (2015) [OT] Democratic Code (2002) Searching multiple dbs (1998) Protect vs Authenicate (1997) [REPLACE] inside [FOUNDITEMS] (1998) RE: type 2 errors with ssl server (1997) Redirect frame targets (1998) typo in docs (2000)