it's still in cfmx admin though:) ----- Original Message ----- From: "Kola Oyedeji" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 23, 2003 5:13 PM Subject: RE: [ cf-dev ] Performance
> > Does that still apply? I seem to recall Ben Forta saying in one of the > meetings that this was true for earlier (pre CF5 versions) but the > restrictions to 100 cached queries was no longer applied. > > Kola > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >> design.co.uk] > >> Sent: 23 October 2003 14:06 > >> To: [EMAIL PROTECTED] > >> Subject: RE: [ cf-dev ] Performance > >> > >> When you get to 100, the next time a query is cached it replaces the > >> oldest one in the list so caching variable queries like that can > nullify > >> the effect of using caching on the server -- basically what is cached > is > >> the query statement once the variables have been calculated. > >> > >> ---- Message from [EMAIL PROTECTED] at 14:01:02 > 2003- > >> 10-23 ------ > >> > > >> >as someone said earlier, the default is for a maximum of 100 cached > >> queries > >> >on a server. so if you've got 1000 different ID's, that would be > 1000 > >> >different cached queries. > >> > > >> > > >> >Duncan Cumming > >> >IT Manager > >> > > >> >http://www.alienationdesign.co.uk > >> >mailto:[EMAIL PROTECTED] > >> >Tel: 0141 575 9700 > >> >Fax: 0141 575 9600 > >> > > >> >Creative solutions in a technical world > >> > > >> > >---------------------------------------------------------------------- > >> >Get your domain names online from: > >> >http://www.alienationdomains.co.uk > >> >Reseller options available! > >> > >---------------------------------------------------------------------- > >> > >---------------------------------------------------------------------- > >> > > >> > > >> > > >> > "Lovelock, > >> > Richard J" To: > >> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > >> > <richard.lovelock cc: > >> > @cgey.com> Subject: RE: [ > cf-dev ] > >> Performance > >> > > >> > 23/10/2003 13:39 > >> > Please respond to > >> > dev > >> > > >> > > >> > > >> > > >> > > >> >yes I was thinking about that latter solution of having a page to > run > >> when > >> >the updated DB is loaded - which runs all of the queries with a > >> "0,0,0,0" > >> >timespan > >> > > >> >think that is the way i will go... > >> > > >> >thing is, with the dynamic queries (e.g. SELECT *, FROM Emp, WHERE > empid > >> = > >> >#form.empid#) would I need to run the query with "0,0,0,0" for > every id > >> - > >> >i > >> >assume there is a cahed query for every outcome of this query which > has > >> >been > >> >run (i.e. if there are 1000 employees it would be 1000 cached > queries > >> not 1 > >> >query)??? > >> > > >> > > >> >_______________________________________________________ > >> >* Regards, > >> > Richard Lovelock > >> >Westminster City Council - Web Support > >> >Cap Gemini Ernst & Young > >> >Southbank > >> >95 Wandsworth Road > >> >London > >> >SW8 2HG > >> >( 0870 906 7482 > >> > > >> >_______________________________________________________ > >> > > >> > > >> >-----Original Message----- > >> >From: Snake Hollywood [mailto:[EMAIL PROTECTED] > >> >Sent: 23 October 2003 13:26 > >> >To: [EMAIL PROTECTED] > >> >Subject: RE: [ cf-dev ] Performance > >> > > >> > > >> >This is what I do. > >> > > >> >I have my queries in a module, the cachedwithin is passed as an > >> >attribute. > >> > > >> >So the main site would include the modules like this. > >> > > >> ><cfmodule template="MOD_NewsQuery" > >> >cachedwithin="#application.cachevariable#"> > >> > > >> >And you setup a variable in your application.cfm for all the various > >> >caching periods you want. > >> > > >> >Now you can call this same module from your admin whenever you > update a > >> >query and pass a cachedwithin value of "0,0,0,0" so the queries > >> >automatically get un-cached. > >> > > >> >Alternately if you are manually uplaoding a new database rather than > >> >using an ADMIN, you can have a single page that CFMODULES all of > your > >> >queries passing a "0,0,0,0" cachedwithin attribute, and will uncache > the > >> >whole lot in one go, so u just run this page when u upload a new > >> >database. > >> > > >> >HTH > >> > > >> >Russ Michaels > >> >Macromedia/Allaire Certified ColdFusion Developer > >> > > >> >CFMX Hosting > >> >Phone: 0845 456 3487 > >> >Tech Support: 0906 9607800 > >> >FAX: 0709 2212 636 > >> >WEB: cfmxhosting.co.uk > >> > > >> >>Please use the support helpdesk on our web site to submit support > >> >tickets.< > >> > > >> >Join our ColdFusion Developer discussion lists. > >> >Send an e-mail to [EMAIL PROTECTED] > >> > > >> > > >> >> -----Original Message----- > >> >> From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > >> >> Sent: 23 October 2003 08:47 > >> >> To: '[EMAIL PROTECTED]' > >> >> Subject: RE: [ cf-dev ] Performance > >> >> > >> >> > >> >> I have some cached queries - some using url/form variables in > >> >> Where clause etc > >> >> > >> >> After updating DB (usually once a week in a big way) the > >> >> changes aren't appearing > >> >> > >> >> The way I am getting around this is to change the > >> >> cachedwithin="#CreateTimeSpan(5, 0, 0, 0)#" in my pages to > >> >> cachedwithin="#CreateTimeSpan(0, 0, 0, 0)#" then uploading > >> >> them and surfing to each to fetch new results from DB. Then > >> >> changing back to cachedwithin="#CreateTimeSpan(5, 0, 0, 0)#", > >> >> then uploading again. > >> >> > >> >> This achieves the results I want in terms of getting the new > >> >> data DB but is there a more efficient way of doing this other > >> >> than changing code/uploading/surfing to pages/changing code > >> >> again/uploading again? > >> >> > >> >> _______________________________________________________ > >> >> * Regards, > >> >> Richard Lovelock > >> >> Westminster City Council - Web Support > >> >> Cap Gemini Ernst & Young > >> >> Southbank > >> >> 95 Wandsworth Road > >> >> London > >> >> SW8 2HG > >> >> ( 0870 906 7482 > >> >> > >> >> _______________________________________________________ > >> >> > >> >> > >> >> -----Original Message----- > >> >> From: Ellwood [mailto:[EMAIL PROTECTED] > >> >> Sent: 22 October 2003 19:47 > >> >> To: [EMAIL PROTECTED] > >> >> Subject: RE: [ cf-dev ] Performance > >> >> > >> >> > >> >> Allan, > >> >> > >> >> Stored procedures don't improve speed that much unless you > >> >> are doing multiple queries in one page. This is then a better > >> >> example for using stored procs because of the lack of client > >> >> server handshaking needed after each query. > >> >> > >> >> Cached queries however are much faster but beware that you > >> >> don't get confused about updates not appearing straight away. > >> >> The way around this is run the query straight after updating > >> >> with a timespan of less than 0 for example > CreateTimeSpan(0,0,0,-1) > >> >> > >> >> Sorry if I have repeated what everyone else has said but my > >> >> computer has been out of action for most of the day due to my > >> >> antivirus picking up a bug and eliminating it rather radically. > >> >> > >> >> -----Original Message----- > >> >> From: Allan Cliff [mailto:[EMAIL PROTECTED] > >> >> Sent: 22 October 2003 10:33 > >> >> To: CF - List > >> >> > >> >> Anyone like to share their opinion on improving coldfusion > >> >> speed either by using stored procedures or caching queries? > >> >> > >> >> Which one is better? Or does it depend on the query. > >> >> > >> >> At the moment I have a mixture of them both with dynamic > >> >> queries as SP and basic queries q_GetCountries and > >> >> q_GetStates as CachedWithin. > >> >> > >> >> Any comments? > >> >> > >> >> Thanks > >> >> > >> >> Allan > >> >> > >> >> > >> >> -- > >> >> ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> >> > >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >> For additional commands, e-mail: > >> >> [EMAIL PROTECTED] For human help, e-mail: > >> >> [EMAIL PROTECTED] > >> >> > >> >> > >> >> ========================= > >> D========================= > >> D===== > >> >> This message contains information that may be privileged or > >> >> confidential and is the property of the Cap Gemini Ernst & > >> >> Young Group. It is intended only for the person to whom it is > >> >> addressed. If you are not the intended recipient, youare not > >> >> authorized to read, print, retain, copy, disseminate, > >> >> distribute, or use this message or any part thereof. If you > >> >> receive this message in error, please notify the sender > >> >> immediately and delete all copies of this message. > >> >> ========================= > >> D========================= > >> D===== > >> >> > >> >> > >> >> -- > >> >> ** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> >> > >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >> For additional commands, e-mail: > >> >> [EMAIL PROTECTED] For human help, e-mail: > >> >> [EMAIL PROTECTED] > >> >> > >> > > >> > > >> >-- > >> >** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> > > >> >To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >For additional commands, e-mail: [EMAIL PROTECTED] > >> >For human help, e-mail: [EMAIL PROTECTED] > >> > > >> > > >> >========================= > >> D========================= > >> D===== > >> >This message contains information that may be privileged or > confidential > >> >and is the property of the Cap Gemini Ernst & Young Group. It is > >> intended > >> >only for the person to whom it is addressed. If you are not the > intended > >> >recipient, youare not authorized to read, print, retain, copy, > >> disseminate, > >> >distribute, or use this message or any part thereof. If you receive > this > >> >message in error, please notify the sender immediately and delete > all > >> >copies of this message. > >> >========================= > >> D========================= > >> D===== > >> > > >> > > >> >-- > >> >** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> > > >> >To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >For additional commands, e-mail: [EMAIL PROTECTED] > >> >For human help, e-mail: [EMAIL PROTECTED] > >> > > >> > > >> > > >> > > >> > > >> > > >> >-- > >> >** Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> > > >> >To unsubscribe, e-mail: [EMAIL PROTECTED] > >> >For additional commands, e-mail: [EMAIL PROTECTED] > >> >For human help, e-mail: [EMAIL PROTECTED] > >> > > >> > >> > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
