On 9/10/00, Jeff Beer penned:
>This is much more efficient, Bud. However, it depends on how long the
>cumulative records are.
>
>I haven't tested this on 4.5+, but under 4.01, if I tried to write a
>variable to disk that was over about 32k, the CF server would spike at 100%
>CPU and lock up completely, requiring a reboot.
Well, as usual I had to test it. And as usual, I'm wrong. LOL
I ran it my way on a query with 3915 records. It created a file 179
KB. It didn't lock up, and that's on Win98 with 4.01 and a whopping
64 MB RAM. But, it did take 4 minutes. Your way took 10 seconds. LOL
So, I think it's safe to say that your way is more efficient AND
safer. :)
Learn something new every day here. I would think that one large
write would be quicker than 4,000 small ones. Certainly not 2,400%
slower. :)
Cool.
--
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.
