Why no cache the query, then sift through it X number of records at a time
using the MAXROW & STARTROW attributes. Kinda like a Previous - Next
operation?
Dave
----- Original Message -----
From: Bud <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 04, 2000 4:15 PM
Subject: Passing a huge variable
> Hi. I have this situation. I'm creating a program for someone where
> their customer's will be billed based on the amount of instances
> (sessions) in a log file. There will eventually be hundreds or
> thousands of customers with each one using up to hundreds of
> sessions. There will be a line in the log file for each session used
> for each customer. Figuring the test file I'm using is 4,000 lines
> long and 400 Kb, 2,000 customers using 200 sessions each will result
> in <gasp>400,000 lines</gasp>. Extrapolating, that gives me a 50 MB
> file.
>
> Now, this is probably extreme, but you never know.
>
> What I want to do is show about 50 - 100 customers per page and have
> it go through the cffile variable and count the lines for each file.
> Then of course, I'll have to click Next to bring up the next group of
> customers.
>
> Reading this 400 Kb file seems to happen pretty well instantaneously.
> But when it gets very large, I'd rather not read the file every
> single time. I don't want to store a HUGE variable in the client
> variable database and I've sworn off session variables.
>
> My question: Do you think the performance hit will be worse reading
> the file at every page load, or passing the variable from page to
> page after initially reading it. And it is even POSSIBLE to pass a
> HUGE variable with a form. And if so, what would be the best way?
> Write a query and store it in a structure or array and pass that? If
> I do it that way, I could just pass the customer ID and the number of
> sessions used (rather than a record for each session used).
>
> Suggestions? Ideas? :)
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
