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:

Credit card types (1997) Location of Browser Info.txt file (1997) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) Nesting [RAW] (1998) Not really WebCat (1997) emailer (1997) stumped (2001) HTML encoding in URLs (1997) Using Web* mail instead of Emailer? (1999) Shipping Via Actual UPS/FEDEX Zones (1999) pop up menu's (1998) SMSI (Scott) clues?? Bug fixes for next WebDNA release (2005) X etc.... (1999) Field name-subcategory (1997) RE: [WebDNA] Advice needed (2013) There's a bug in the math context ... (1997) Latin Characters (1998) Upgrading old WebCat Database Files (1997) emailer (1997) Re:trouble (1997)