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:

SSL and reg web* (1997) [WebDNA] WebDNA on Linux (2009) Dubble Sku's in a Database (1999) Web Catalog 2 demo (1997) no [include]s with encryption? (1998) Sorting nested search (2003) RE: Problems with dbcatalog.exe (1997) [sendmail] and [formvariables] (1997) normal users.db calls ... (1998) WebMerchant Process Orders errors (2000) Robert Minor duplicate mail (1997) This Code Kills My WebCatalog Dead (2003) Upgrading old WebCat Database Files (1997) Date Sorting (1997) Suffix Mapping (1997) Plugin or CGI or both (1997) Math Function (1997) Version 4? (2000) [WebDNA] online.db deadlock: your current options ... (2011) Moving a record from one dataabse to another. (2000)