> -----Original Message----- > From: gabriel l smallman [mailto:[EMAIL PROTECTED] > Sent: Monday, December 27, 2004 8:27 PM > To: CF-Talk > Subject: RE: Slow (sorta) site issues - Ideas? > > Couple of thoughts: > > 1. Flatten every page you can to html
I'm loath to do that just because I'd lose my clickstream caching... but then again it'd be better to lose some data than the site. > 2. Take a look at cfaccelerate sp? Basically saves flattened html in the > app. Scope. If your sneaky you can cache chunks of the page even if its > dynamic much of the page is not. I do some of this as it is (navigation for example)... but I'll take a look. I'm sure I could do more. > 3. turn on trusted cache (you will get a nice boost) Unfortunately not under my control (this is a shared hosting account - we're not the only app on the box). > 4. pray! Well... I'm an atheist, but I get your drift. ;^) > 5. cache every query you can even if for 10 seconds The application is already pretty heavily optimized. The only real queries being done is the session manager (which would definitely not benefit from caching). The main events database, for example, is loaded directly into an Application scoped CFC bundle. It makes accessing event data insanely fast compared to DB calls. The festival itself is large by any standard, but doesn't represent a whole lot of data (about 200 artists at something like 60 venues). Loading it all into memory is the biggest speed boost I can get (which I've done). This leaves the database doing only two things: saving and fetching visitors "plans" (saved events) which is pretty peppy and storing session data. Neither can benefit from query caching. > Btw.. What does a company like crystal tech charge to host? All sorts of prices. ;^) The account we're getting (VERY feature rich) is only $26 a month (with SQL Server, tons of space, a generous bandwidth allotment). CrystalTech has upped limits and features twice and dropped prices once since I've been with them. They're a very good CF host - any problems this site has on the 31st can't truly be blamed on them. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188840 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
