On 3/13/07, megan c wrote:
> Thanks for the suggestion. For one of my sites I'm going to need to do
> something along
....
It is EASY with cfhttp (if you've got well formed data), but I have
never load tested it.
or (not nearly as easy)
If you've got createObject "power" you can use HSSQLDB, which seems pretty
robust for CSV stuff- but CFHTTP is probably fastest from 0 to Query.
The one advantage to rolling your own, is you can do it all in one statement (if
it's really well formed, mind), with the old
INSERT INTO table (col1,col2,col3)
VALUES (
("row","one","values"),
("row","two","values"),
("row","three","values")
)
Or something like that. Instead of 2000 inserts, you can do one- but it'll
be a monster.
Just another option or two to keep in mind, or whatnot.
Happy hunting!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272617
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
