thanks, this solution worked great and is now processing at a steady 2 seconds
Hey, maybe try something like this? I haven't tested this, but it
should theoretically be faster
cfset sqlstring = /
cfset questionIDLen = arrayLen(questionIDArray)!---put this in a
variable so it
thanks for providing the details as to what is happening behind the scenes
On Wed, Nov 10, 2010 at 12:40 AM, Richard White wrote:
[query with 6600 cfqueryparams taking 9 seconds vs. 1 for plain
SQL]
In understand that adding the cfqueryparam is adding approx 6600
validations, however
transferring data from one app to another
Hi,
I am running the following cfquery which inserts a large amount of
rows into a table (approx 2200)
Just out of curiosity, where does your insert data originate from?
~|
transferring data from one app to another
I'd just use Navicat to transfer the data. No CF needed. Quick and easy.
Will
~|
Order the Adobe Coldfusion Anthology now!
nice link, thanks will!
transferring data from one app to another
I'd just use Navicat to transfer the data. No CF needed. Quick and easy.
Will
~|
Order the Adobe Coldfusion Anthology now!
Hey, maybe try something like this? I haven't tested this, but it should
theoretically be faster
cfset sqlstring = /
cfset questionIDLen = arrayLen(questionIDArray)!---put this in a variable so
it doesn't re-evaluate 2200 times---
cfset questionIDCheck = 0
cfloop index=i from=2
Hi,
I am running the following cfquery which inserts a large amount of
rows into a table (approx 2200)
Just out of curiosity, where does your insert data originate from?
~|
Order the Adobe Coldfusion Anthology now!
On Wed, Nov 10, 2010 at 12:40 AM, Richard White wrote:
[query with 6600 cfqueryparams taking 9 seconds vs. 1 for plain SQL]
In understand that adding the cfqueryparam is adding approx 6600 validations,
however would it really be the cause of slowing this query down so much?
cfqueryparam is
Hi,
I am running the following cfquery which inserts a large amount of rows into a
table (approx 2200)
cfquery name=insertData datasource=dbname
INSERT INTO parentquestions
VALUES
cfloop index=i from=1 to=#arraylen(questionIDArray)#
cfif i neq 1,/cfif
(cfqueryparam
9 matches
Mail list logo