What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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 = 103032
interpreted = N
texte = Govinda wrote: > Hi all > > I am writing to ask those of you who have worked with really big db's > what is your experience. (I.e. million+ records.) > We are within the next weeks/months going to be setting up a site seeded > with a couple huge existing db's. One is 2 GB. The other is closer to > 1 GB. There will be some smaller db's we'll add in, but I am first > wanting to get your vote of confidence about using WebDNA in the first > place for this site. If it needs to be a dedicated server so that we > can have all the HD and RAM for ourself, then we will. Is it reasonable > to expect we can get the site running, *happily* with native WebDNA db's > that size? > OR is it reasonable to expect we can get the site running, *happily* > with MySQL db's that size and we use WebDNA to talk to them? How are > people finding the [SQL] tags in large heavy production environments (if > I said that right)? > > Or, do you feel we really should go PHP/MySQL to save pain later? (I > sure hope not, but eating the bitter pill now is far less painful than > after months of work that has to be all redone.) > > Thanks for any feedback! > > ------------ > Govinda > govinda.webdnatalk@gmail.com With the info you gave, it's not 100% clear as to a suggestion... but likely I guess I'd go with the WebDNA/MySQL direction for the large data sets and WebDNA .db's for the smaller ones. Some things that would/could be a factor are: how often these .db's are hit. What kind of searches will be performed (the code involved in accessing the data) You actually may benefit from our new 64bit linux build on this one. 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)
Govinda wrote: > Hi all > > I am writing to ask those of you who have worked with really big db's > what is your experience. (I.e. million+ records.) > We are within the next weeks/months going to be setting up a site seeded > with a couple huge existing db's. One is 2 GB. The other is closer to > 1 GB. There will be some smaller db's we'll add in, but I am first > wanting to get your vote of confidence about using WebDNA in the first > place for this site. If it needs to be a dedicated server so that we > can have all the HD and RAM for ourself, then we will. Is it reasonable > to expect we can get the site running, *happily* with native WebDNA db's > that size? > OR is it reasonable to expect we can get the site running, *happily* > with MySQL db's that size and we use WebDNA to talk to them? How are > people finding the [SQL] tags in large heavy production environments (if > I said that right)? > > Or, do you feel we really should go PHP/MySQL to save pain later? (I > sure hope not, but eating the bitter pill now is far less painful than > after months of work that has to be all redone.) > > Thanks for any feedback! > > ------------ > Govinda > govinda.webdnatalk@gmail.com With the info you gave, it's not 100% clear as to a suggestion... but likely I guess I'd go with the WebDNA/MySQL direction for the large data sets and WebDNA .db's for the smaller ones. Some things that would/could be a factor are: how often these .db's are hit. What kind of searches will be performed (the code involved in accessing the data) You actually may benefit from our new 64bit linux build on this one. 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:

Plugin or CGI or both (1997) unable to launch acgi in WebCat (1997) Looking for WebDNA 3.08 MAC (2003) Lookup Notfound (1998) [WebDNA] Version 7.x: webdna.ini and EmailerPrefs (2012) SiteGuard Use Question (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) [showif],[refferer],[include] in errormessages.db (2002) Anyone using Editize (inline html editor) w/ WebDNA (2003) How can I Add several Items into the cart at once? (1997) [convertChars] and HTML Tags (1997) Carts & Refering URLs (1997) Stinkin' [Referrer] (1998) WebCatalog Technical Reference (1997) WC2.0 Memory Requirements (1997) Running 2 two WebCatalog.acgi's (1996) searching multiple databases in single search (1997) Summarising on two fields (1998) Version f1 status (1997) Max Record length restated as maybe bug (1997)