At 11:59 AM -0800 1/3/01, paul smith wrote:
>At 10:35 AM 1/3/01 -0700, you wrote:
>>You may want to consider the alternative of storing the content of
>>the html pages in the database and generate the "pages" dynamically
>>when requested.
>>
>>Not all sites lend themselves to this, but for those that do, the
>>impact can be dramatic (especially in the creation and maintenance of
>>the content),
>
>Which ones do not?
You would not gain many of the advantages of dynamic content if the
page content, once established, never changed...
>
>>This can easily outperform serving static pages.
>
>This is surprising given that in both cases a file needs to be read. In
>your experience, when does a SQL approach outperform, and when not?
The site performed better as a whole because of CF's caching of queries...
Because of a high incidence of the same query being issued by many
visitors, visitors after the first performed better.
As the site traffic increased, the site tended to perform better
(greater probability of a query being in the cache)
>
>best, paul
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
