Re: when to use SQL over webcat?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36277
interpreted = N
texte = John,I seem to remember that thread. I think I was the one that asked the original question.Grant's answer indicated that there was a point of saturation with large databases with many records in WebCatalog where the time to complete a function such as a search on data in RAM started to become slower than the time to make a call to an SQL database on another server and have that server return the results.I don't recall that he knew exactly what that point of saturation was because I think it varies from one situation to the next.I know this sounds vague, but I think at this point many of us have proven that you will run into deadlock and thread problems long before you reach that saturation point he was referring to.Paul>Once while cruising the archives, I read a post where Grant gave his >recommendation>when SQL was preferred/needed over webcat. If my memory is right, >then among other>things he said. ..when the data needs to be shared across more than >server... (not>an exact quote)>>That was a pretty old post (and plus I am not finding it now) so I >want to ask this>question again as we are working on a portal that will hopefully >quickly outgrow>anything we plan/build now ;-)>>Assuming *tons* (how many daily users does a low-mediumly popular >portal get?) of>unique users mostly reading from db's, but ~several hundred-1,000 >of them writing to>those same few db's daily....>>at what point would SQL be the recommendation over webcat?>Only when more than one box was needed to run the works? Or >sometimes sooner than>that?>>What are key issues to consider?>>-John>>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list
.>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://search.smithmicro.com/ _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\__/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
John,I seem to remember that thread. I think I was the one that asked the original question.Grant's answer indicated that there was a point of saturation with large databases with many records in WebCatalog where the time to complete a function such as a search on data in RAM started to become slower than the time to make a call to an SQL database on another server and have that server return the results.I don't recall that he knew exactly what that point of saturation was because I think it varies from one situation to the next.I know this sounds vague, but I think at this point many of us have proven that you will run into deadlock and thread problems long before you reach that saturation point he was referring to.Paul>Once while cruising the archives, I read a post where Grant gave his >recommendation>when SQL was preferred/needed over webcat. If my memory is right, >then among other>things he said. ..when the data needs to be shared across more than >server... (not>an exact quote)>>That was a pretty old post (and plus I am not finding it now) so I >want to ask this>question again as we are working on a portal that will hopefully >quickly outgrow>anything we plan/build now ;-)>>Assuming *tons* (how many daily users does a low-mediumly popular >portal get?) of>unique users mostly reading from db's, but ~several hundred-1,000 >of them writing to>those same few db's daily....>>at what point would SQL be the recommendation over webcat?>Only when more than one box was needed to run the works? Or >sometimes sooner than>that?>>What are key issues to consider?>>-John>>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://search.smithmicro.com/ _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\__/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Paul Uttermohlen
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:
2.1 Stuff (1998)
[WebDNA] Will Q2/2010 be the best quarter for WebDNA? (2010)
[WebDNA] [OT] the "Work in progress" thread. (2009)
[BULK] [WebDNA] Can WebDNA corrupt a db? (2012)
[WebDNA] MacWorld - Jan 2009 (2008)
WebCatalog for guestbook ? (1997)
Help--WebCat setup (2000)
WebCommerce: Folder organization ? (1997)
[OT] Theiving B*****ds (2004)
[shownext] and sort (1998)
creating a ShipCosts database (1997)
multipart part 2 (2004)
[format 40s]text[/format] doesn't work (1997)
Setting vars in a text file..... (2004)
WebCat2 several catalogs? (1997)
OT: Site Test (2006)
[addlineitems] display (1997)
includes and cart numbers (1997)
authenticating a second user (1997)
Server Freeze (1998)