RE: query caching (was: RE: CFC performance difficulties)

2003-06-29 Thread Dave Watts
Is there any documentation on how to handle cached queries across a load balanced environment? No, not to my knowledge. I've noticed some oddities on ours, and was wondering if we were missing something obvious. Could you be more specific? Are you referring to caching queries using the

Re: CFC performance difficulties

2003-06-27 Thread Calvin Ward
] Sent: Thursday, June 26, 2003 6:54 PM Subject: Re: CFC performance difficulties On Thursday, Jun 26, 2003, at 12:12 US/Pacific, Mike Pacella wrote: Thanks for the reply Sean. My one question is that I've been doing Java for about 2 years and this is primarily the methodology we

CFC performance difficulties

2003-06-27 Thread Mike Pacella
Thanks for the feedback, Brian Sean. I think it'd be best to just deal with the query objects as opposed to creating these massive structures of CFCs (since Cold Fusion query objects are one of the most powerful facets of the language). If I need to deal w/ one particular object, then it

CFC performance difficulties

2003-06-26 Thread Pacella, Michael
Has anyone experienced slow downs when passing around several CFCs as objects ? Here's the problem we have run in to: To encapsulate information about all of the Campuses in our database, a CFC was created to act sort of like a Java object representing campus (complete with properties such as

Re: CFC performance difficulties

2003-06-26 Thread Sean A Corfield
On Thursday, Jun 26, 2003, at 08:36 US/Pacific, Pacella, Michael wrote: Another CFC was created to access the database, performing functionality such as search. Search would query the DB, and then step thru the results, creating Campus CFC objects for EACH campus returned. The end result

RE: CFC performance difficulties

2003-06-26 Thread Rich Z
business (or more specifically end-user) goals to drive the design. -Rich -Original Message- From: Pacella, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 11:37 AM To: CF-Talk Subject: CFC performance difficulties Has anyone experienced slow downs when passing around several

CFC performance difficulties

2003-06-26 Thread Mike Pacella
Thanks for the reply Sean. My one question is that I've been doing Java for about 2 years and this is primarily the methodology we, as a company subscribed to.In situations where we had objects that would need to be looked up frequently, we'd create Hashtables whose values would be the

RE: CFC performance difficulties

2003-06-26 Thread Bryan Love
26, 2003 12:12 PM To: CF-Talk Subject: CFC performance difficulties Thanks for the reply Sean. My one question is that I've been doing Java for about 2 years and this is primarily the methodology we, as a company subscribed to.In situations where we had objects that would need to be looked up

CFC performance difficulties

2003-06-26 Thread Mike Pacella
cfcomponent hint=Creates the CampusDAO CF component, which will provide database interaction with the Campus table displayName=CampusDAO !--- Function:

RE: CFC performance difficulties

2003-06-26 Thread Bryan Love
[mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 12:48 PM To: CF-Talk Subject: CFC performance difficulties cfcomponent hint=Creates the CampusDAO CF component, which will provide database interaction with the Campus table displayName

RE: CFC performance difficulties

2003-06-26 Thread Bryan Love
performance difficulties cfcomponent hint=Creates the CampusDAO CF component, which will provide database interaction with the Campus table displayName=CampusDAO !--- Function: selectCampuses Purpose

Re: CFC performance difficulties

2003-06-26 Thread Sean A Corfield
On Thursday, Jun 26, 2003, at 13:07 US/Pacific, Bryan Love wrote: Wow, you have a lot going on here. It's no wonder it takes a while to execute Is there any reason you do not want to run two queries instead? You are transferring the work load of the DB to the CF server in the code

Re: CFC performance difficulties

2003-06-26 Thread Sean A Corfield
On Thursday, Jun 26, 2003, at 12:12 US/Pacific, Mike Pacella wrote: Thanks for the reply Sean. My one question is that I've been doing Java for about 2 years and this is primarily the methodology we, as a company subscribed to.In situations where we had objects that would need to be