intervals and pulls in 10k+ line csv files for import into a cf db
I used Paul Vernon's CFX_pop3 to speed up the processing
(*dramatically*) of the 4-5mb file attachments, and Ryan Emerle's new
java cfx_text2query to read in the data. Another huge jump forward in
speed. Then I did the query loop you describe, but the time that step
takes up is negligible compared to the cffile read and interpretation.
I found that loop took up only a small fraction of my total job time
when running in about 16000 records from a 4.7mb csv file.
DTS would have been nice but it wasn't a sql server job.
--
--Matt Robertson--
President, Janitor
MSB Designs, Inc.
mysecretbase.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
