In a shared environment you have to ask yourself to what degree optimizing the performance of your site's code is ultimately going to improve your web site's performance. Even if you were to increase performance 10-fold it's unlikely you'll see anywhere near that performance gain if there are 200 other web sites on the same server. It will of course depend on what those other sites are doing when yours is busy, but you have so little control over this that all you can do is cross your fingers. If you knew that your site was going to use a significant percentage of the server's resources then it may be worth the effort. If you don't know this then it's just a crap-shoot.
----- Original Message ----- From: "Jim Davis" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, December 27, 2004 8:38 PM Subject: RE: Slow (sorta) site issues - Ideas? >> -----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:188847 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
