_____
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: 01 March 2004 13:47
To: CF-Talk
Subject: Re: SQL Multiple Inserts
But will it help in terms of performance? My understanding is that Stored
Procedures are cached queries. But if the query you use has different
variable values everytime, then it's just like using a new query. no
performance benefit. But if this is not the case, the I would totally use a
stored procedure for this part!!
----- Original Message -----
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Monday, March 01, 2004 7:34 AM
Subject: RE: SQL Multiple Inserts
No, thats the whole point of a stored procedure...you pass it in variables
and it does the processing....
_____
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: 01 March 2004 13:32
To: CF-Talk
Subject: Re: SQL Multiple Inserts
Here's what i thought about stored procedure. I thought they are only
useful when the SQL query isn't dynamic, like SELECT * from tbl_images.
But
if it's something like SELECT * from tbl_images where project_id = 30,
then
a stored procedure is not beneficial, because it's essentially a different
query every time.
Is this correct? My queries are like the latter.
----- Original Message -----
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Monday, March 01, 2004 6:14 AM
Subject: RE: SQL Multiple Inserts
Stored Procedure : BULK INSERT.
_____
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: 01 March 2004 12:16
To: CF-Talk
Subject: SOT: SQL Multiple Inserts
Hey guys, let's say I have to insert like 5,000 rows of data with the
click
of a button in my app. Would it be alot faster to insert all 5,000 in
one
CFQuery with multiple inserts? Right now it is just one query looped
5,000
times.
Also are there any drawbacks with using multplie inserts?
Thanks
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
