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:
|
- 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)
- 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)
- 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)
- Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
- 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)
- Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
- 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)
- 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)
- Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
- Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Patrick McCormick 2009)
- Re: [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (Govinda 2009)
- [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)