Hi When u say HSSQLDB you mean ?? Can you tell me any capability you know that can make my process faster. I am using so many file operations 1> Reading CSV from FTP and upload 2> Then storing in MySQL DB 3>Another query to get the values and doing some operation on those values ( for that i am using cfhttp
creating files and zip..so its a very slow process right now. Do you know any faster way? >On 2/28/07, Deepak Gupta wrote: >> Thanks a lot Man.. it worked... > >Sweet! Glad I could help. > >If you have access to createObject, HSSQLDB has some >excellent CSV handling capabilities. > >Plows right through stuff that you can't, for whatever reason, >import using cfhttp. BTW, cfhttp will take CSV and turn it >into a query- so long as it's pretty well formed CSV-- in >case you weren't aware. > >Another way to skin the cat, what what. [= ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
