Can I have multiple INSERT statements inside a single CFQUERY? What's the
maximum string size that ODBC can handle? If I wrap the CFQUERY inside a
CFTRANSACTION, will there be a performance penalty?
I'm running SQL Server 7 & ColdFusion 4. I'm working on speeding up a
massive file import. The sql is totally straightforward -- just a bunch of
INSERT...VALUES commands. But there could potentially be thousands of them.
Any advice?
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
