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

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103033
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 > 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 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 [SQL] tags, else skip WebDNA altogether? (christophe.billiottet@webdna.us 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? (Govinda 2009)
  10. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Patrick McCormick 2009)
  11. Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
  12. [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 > 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 Govinda

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:

how many tags? (2001) Robots fill event log (1997) PIXO (1997) [SMSI] WebDNA is too good to go away! (2006) Security Issue (1997) Beta List (1998) Expiration of Carts (1997) problems with 2 tags shakur (1997) (1998) Webdna is dead! (2003) WebCatalog for UNIX Released ( was How true is this? ) (1999) Problems deleting when a search field is blank... (1998) [returnraw] and form variables (1998) 2nd WebCatalog2 Feature Request (1996) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) PCS Frames (1997) international time (1997) Problems with [Search] param - Mac Plugin b15 (1997) pop up menu's (1998) Size Limitation through a POST via SSL? (2005)