How about this?
1. Initialize the value of each cell to null:
<cfloop from="1" to="168" index="iCell">
<cfset tmp = SetVariable("cell#iCell#", "")>
</cfloop>
2. Do one query to get all events.
3. Loop through the events. For each event, determine what cell it
belongs in, and update the value of that cell.
4. Build the table in a loop, putting the value #cell#iCell# into each
cell.
-David
On Fri, 12 Jan 2001 19:00:10 -0800 "Brent Goldman" <[EMAIL PROTECTED]>
writes:
> Hi,
>
> I am currently developing a resource scheduler. The table that
> outputs each
> schedule has 24 rows on the left: 12 hours with half-hour
> increments. There
> are 7 columns on the top: one for each day of the week. Total,
> there will
> be 24*7=168 different cells which need to be populated with events
> if there
> are any.
>
> There are two different ways to accomplish this. One way is to do a
> query
> to the database in each and every cell, but 168 queries is a
> tremendous
> amount of queries for one page load. If there are 10 events in the
> database, the page load is about 600 ms with SQL Server.
>
> The second way to accomplish this is do have a master query at the
> top of
> the page that retrieves each and every element in the database
> relevant to
> the current page. Then, within each cell, do a CFOUTPUT or CFLOOP
> through
> the query, and if the data is the one we want, output the results.
> This
> way, if there are 10 events in the database, and there are 168 loops
> (one
> loop for each cell), there is a total of 168*10=1680 times the if
> statement
> (and possibly the code within the if statement) is executed.
> Overall, the
> page load of this way is about 700 ms with SQL Server, with about
> 10-20 ms
> added for each event added into the database.
>
> The first way is definately better for page load and scalability,
> but it is
> not very efficient to have 168 queries for a single page load. Does
> anyone
> have any comments about the two different ways or new ideas on how
> to
> accomplish this project?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
