Re: Webcat XML/XSLT Performance vs. static Html
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66251
interpreted = N
texte = Adam O'Connor wrote:> Regarding products there are well over 30k, and products is one of > several portions of the site accessed daily by over 12k users, who > probably access these detail pages over and over while using the site. > We have noticed similar sites in this vertical market use a dynamic > technology like webcat to serve static html pages - this is giving them > very fast page loads under heavy traffic loads - obviously because there > is little to process if anything.> > Although we could rewire our detail pages, 'programmatically' speaking, > our goal is to serve these detail pages without having to create db > connections. My idea is to create a small xml file everytime a user adds > a product and/or re-write this xml file anytime a modification has taken > place. Therefore, the xml file would mirror what is in the db. So when > a user clicks to see a product's details from the results page, they > would be served a static page - therefore not needing to access our SQL > sever.The SQL part is something I didn't know about. I don't believe that SQLquerries are RAM based.. right? I would think the SQL database has thepotential of causing slowness... but I haven't done enough with SQL to knowfor sure. 30K products is a lot, but I still wonder if there isn't somethingelse that could be done (besides static pages).> In order to keep this manageable as possible, I would like to use one > xsl file to display these xml files, via webcat's xslt function. > Therefore, I would have 30k+ xml files and 1 xsl file. The details page > would have one like of script, a script that grabs the xml file and > merges it with the xsl file.> > > This why I am wondering how resource intense webcat's xml/xsl features. > I know it wouldn't be a big deal on a small/medium scale, but are > situation is larger.Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Adam O'Connor wrote:> Regarding products there are well over 30k, and products is one of > several portions of the site accessed daily by over 12k users, who > probably access these detail pages over and over while using the site. > We have noticed similar sites in this vertical market use a dynamic > technology like webcat to serve static html pages - this is giving them > very fast page loads under heavy traffic loads - obviously because there > is little to process if anything.> > Although we could rewire our detail pages, 'programmatically' speaking, > our goal is to serve these detail pages without having to create db > connections. My idea is to create a small xml file everytime a user adds > a product and/or re-write this xml file anytime a modification has taken > place. Therefore, the xml file would mirror what is in the db. So when > a user clicks to see a product's details from the results page, they > would be served a static page - therefore not needing to access our SQL > sever.The SQL part is something I didn't know about. I don't believe that SQLquerries are RAM based.. right? I would think the SQL database has thepotential of causing slowness... but I haven't done enough with SQL to knowfor sure. 30K products is a lot, but I still wonder if there isn't somethingelse that could be done (besides static pages).> In order to keep this manageable as possible, I would like to use one > xsl file to display these xml files, via webcat's xslt function. > Therefore, I would have 30k+ xml files and 1 xsl file. The details page > would have one like of script, a script that grabs the xml file and > merges it with the xsl file.> > > This why I am wondering how resource intense webcat's xml/xsl features. > I know it wouldn't be a big deal on a small/medium scale, but are > situation is larger.Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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://webdna.smithmicro.com/
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:
Verisigns SDK (pay flo pro) (2002)
Help ..... with better explanation (2001)
page redirect in webDNA (1997)
groups and [ShowNext] (1997)
Music in background (2000)
WebCatalog vs. Cold Fusion (1998)
RE: Adding headers to email (1997)
WebCat2 Append problem (B14Macacgi) (1997)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
Re1000001: Setting up shop (1997)
Help! I've fallen in Structured Query Language and can'tget (2002)
WebCatalog for Postcards ? (1997)
Converting characters to numbers ... (1997)
SAVECART (1997)
WebCatalog 2.1b4/Mac available (1997)
can WC render sites out? (1997)
Summing results of a nested search (2006)
Error: this shopping cart has already been submitted and (2006)
WebDNA Docs (2003)
[WebDNA] Cookie behavior (2010)