Some other tips 1) Index the database 2) Turn on Maintain Database connections in CFAdmin 3) Make sure the JVM is tuned 4) Cache as much commonly accessed data as makes sense 5) Reduce/Remove file I/O operations where possible
On 10/24/07, Mark Ireland <[EMAIL PROTECTED]> wrote: > > Thanks. I am in a situation where I know when the spike will be (the > duration), exactly what hardware setup the app is using and (roughly) how > many users will hit the app > > I have a maximun number of db connections (that will be exceeded) > > I have turned four queries into one (assuming fewer queries per user is an > improvement) > > I think I could put the app in its own instance. > > Any suggestions? > > ------------------------------ > Date: Tue, 23 Oct 2007 23:02:01 -0400 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: [CFCDEV] Re: scope and spike > > If it is a Singleton, put it in the application scope. If it is specific > to user, put it in the session scope. (Pretty much the same rules that apply > to any other kind of data). However, without more details on what the CFC > does and what context it is used in, it's pretty much impossible to give a > definite answer. > > On 10/23/07, *Mark Ireland* <[EMAIL PROTECTED]> wrote: > > If you are writing an app that must cope with a big spike in load which > scope is best for a cfc? > > Thanks > > ------------------------------ > Sell your car for just $30 at CarPoint.com.au. It's > simple!<http://a.ninemsn.com.au/b.aspx?URL=http://secure-au.imrworldwide.com/cgi-bin/a/ci_450304/et_2/cg_801459/pi_1004813/ai_859641&_t=762955845&_r=tig_OCT07&_m=EXT> > > > > > > ------------------------------ > Sell your car for just $30 at CarPoint.com.au. It's > simple!<http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT> > > > -- "Come to the edge, he said. They said: We are afraid. Come to the edge, he said. They came. He pushed them and they flew." Guillaume Apollinaire quotes --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
