Yeah, it's true. He could even create a script in an OS task that will load the file to a DB every time it's changed...or do it with a scheduled CF page, if that is preferred (I'd chose the former if it were me, I've never really trusted CF's scheduler).
> -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 19, 2006 4:44 PM > > Indeed, but for sure a DB process will be a hell of a lot > faster and more > importantly not tie up a thread :-) > > -----Original Message----- > From: Munson, Jacob <[EMAIL PROTECTED]> > Sent: Thu Jul 20 00:01:13 2006 > > I'll agree with Robert that CF is slow at file/text manipulation (I > really hope they improve this in the next version, and yes I've bugged > sent in a feature request). That said, you can loop over the file var > with cr/lf as your delimiters, and then each loop item, or in > this case > each row, will be a list. CF has a lot of builtin functions for > manipulating lists. > > > -----Original Message----- > > From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 19, 2006 4:00 PM > > > > Has anyone ever queried a comma delimited flat file in CF7? > I have 2 > > frequently updated files of around 15MB and 3MB, and don't > > want to import it > > into a database every time it changes. How efficiently can > > CF7 query a > > large file like that? Can I do calculations, filtering, etc. > > similar to a > > database query? Any other suggestions on how I might > accomplish this? > > Thanks. > > This transmission may contain information that is privileged, > confidential > and/or exempt from disclosure under applicable law. If you are not the > intended recipient, you are hereby notified that any > disclosure, copying, > distribution, or use of the information contained herein > (including any > reliance thereon) is STRICTLY PROHIBITED. If you received > this transmission > in error, please immediately contact the sender and destroy > the material in > its entirety, whether in electronic or hard copy format. > Thank you. A1. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247177 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
