I'll make a recommendation here that may or may not apply, but may be worth
noting. This is assuming ms sql Server.
Insert...values...
Insert...values...
, n
Will be much slower from SQL perspective than:
Insert...
Values(...)
, (...)
, (...)
, n
Or
Begin tran
Insert... Values...
Insert...
Running a page that reads a text file into an array - then writes the
array to the database.
I get the following error:*
Detail:* [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming
tabular data stream (TDS) remote procedure call (RPC) protocol stream is
incorrect. Too many
You can either remove your CFQUERYPARAMs (which might be ok if your
data isn't coming from an untrusted source), or you can limit your
batch size so you don't exceed 2100 parameters per CFQUERY tag.
Might try this first. It's from inside a client admin system, and
there's a specifically
or you could make sure your loop doesn't exceed 350 records (2100
divided by 6) by having an outer loop and an inner loop.
Could this be a job for cfthread? Split a large list up into 4 or 5
threads and just let them run (as soon as I get my head around the
math... heh)? Seems that would
You can either remove your CFQUERYPARAMs (which might be ok if your data
isn't coming from an untrusted source)
This works. Tried it with a list of roughly 1000 records.
Will try my 15,000 record sheet later this evening and see what happens.
Added 4 threads to split all list up as well.
5 matches
Mail list logo