On 6/12/07, Ben Forta wrote: > > >> CF may be able to do the same thing, but the fact that Ben Forta > >> didn't mention it doesn't bode well for that being true. > > It's doable, via the text ODBC driver, but it's slow, and the SQL is a > pain. > > I still think the best option is to do this in the DBMS.
I'm gonna go with Ben on this one, but you might want to give HSSQLDB a shot... it can use CSV files as it's tables and can be pretty quick. Never tried it on anything over a few megs, but it handles those alright. If you're curious, I can send some example code for firing an instance of HSSQLDB up in the app scope... seriously tho, using a LOAD DATA type command from MySQL will probably be the easiest... ASSUMING, of course, that the CSV is in a format that jives with what you gots to do. Otherwise, you'll be busting that java line reader and wanking with the data before doing anything else... GIGO, basically. Don't get me started on *cough* um, poorly formatted *cough* CSV files... *walks away muttering to self* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
