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... Va
> 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. Sp
> > 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
> 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
> 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 pa
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 parameters w
6 matches
Mail list logo