some data manipulation within the database then when done outside the
database, i.e. looping over 10.000 records to perform an action on a
value/column will certainly be quicker within the RDBMS then outside in
coldfusion.
I have seen people bring CF down with some of the looping they do, CF is not
made for looping over LARGE record sets, and data cleansing etc. In short,
use Cursors when working with a large record set, and when you are not just
displaying the data but working with it..
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: G [mailto:[EMAIL PROTECTED]
Sent: Saturday, 14 February 2004 12:43 AM
To: CF-Talk
Subject: Re: OT- Sort of Loop in SQL
Cursors are rather clunky and not particularly efficient. I suspect a
primary reason for converting SQL/CF functions to a pure SQL environment
would be for the increased efficiency.
However, in order to realize this advantage fully, you really need to work
within the "SQL world". This means applying relational solutions to
sequential problems.
In short, I'm not sure much is gained (efficiency wise) by replacing Cold
Fusion (or any other sequential processor) with SQL cursors.
Brian Grant
Senior Programmer
SI International
www.si-intl.com
----- Original Message -----
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: Friday, February 13, 2004 7:55 AM
Subject: RE: OT- Sort of Loop in SQL
A cursor is the SQL Ability to performa a loop etc...Are you on SQL
Server?
If so, open up Query Analyser and select Help > Books Online.
Search for Cursors
This will give you all the info you need!
_____
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 13 February 2004 13:51
To: CF-Talk
Subject: Re: OT- Sort of Loop in SQL
What are cursors? Could you show me some sample code?
----- Original Message -----
From: MILAN MUSHRAN
To: CF-Talk
Sent: Friday, February 13, 2004 8:30 AM
Subject: RE: OT- Sort of Loop in SQL
You can use cursors.
>From: "Mickael" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT- Sort of Loop in SQL
>Date: Fri, 13 Feb 2004 08:23:04 -0500
>
>Hi All,
>
>I know how complete the following task in CF and SQL but I was
wondering
if
>there is a way to do it with only SQL. What I am trying to do is
modify
>records sequentially in my database.
>
>I have a field in my database called destination, this is an office
>location. And I have many records in my database that I would like to
>assign 1/3 of the records to each of the three offices. I don't want
to
>just do an update top (then 1/3) and set the office to each of the
office
>ids. I was wondering if there is a way in SQL to update the first
record
>to the first office ID, then the second record to the second office id,
>then the third to the third office id, then the forth record to the
first
>office id and continue that way.
>
>Is this possible in SQL? There are Network security issues that won't
let
>me connect to this database with CF.
>
>Mike
>
>
>
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
