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
]
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
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
Michael:
I'll admit that I don't have years of OO experience behind me, but in my
experience I've found that many of the applications I've designed/built
share a very common paradigm: objects that require a line-item view
(e.g. lists and search results) and a zoomed-in or detailed view
(often
post the code you are using to create the array of structs from the query
results.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
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
below - you should let the DB do what it does best.
You'll need one query to
also
if you insist on doing it with one query you have other options... cache the
query and use this (untested code):
cfset campusList = valueList(selectCampuses.campusCode)
cfset idx = listFind(campusList,chosenCampusCode)
!--- output info ---
cfoutput
#selectCampuses[idx].campusCd#
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
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
9 matches
Mail list logo