Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
_____
From: Raster, Tim [mailto:[EMAIL PROTECTED]
Sent: Friday, 20 February 2004 2:46 AM
To: SQL
Subject: RE: SQL server timing out
Did you check for locks on your tables? Perhaps you have 2 processes
colliding somewhere.
-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 18:05
To: SQL
Subject: SQL server timing out
Can anyone point me in the right direction here, SQL server here is
timing
queries out, I am trying to find the bottleneck but am not sure where to
begin looking.
The machine is a web server, SQL server running IIS5.0 and windows 2000
as
well as coldfusion.
Coldfusion is running fine, but the queries are just timing out. A quick
look in perfmon, and I can't see any memory problems or SQL takes
running
too long.
Any suggestions....
Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
_____
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, 18 February 2004 8:43 PM
To: SQL
Subject: RE: Locking Records
Well, you can do it this way but via SQL wouldnt be a good option (not
by
thread locking) as it will stop anyone from doing anything on your DB
until
that lock has been released. You can always throw some lockids in the
shared scopes of CF or even as flags in the record itself : such as
bLocked
(BIT) which flags to 1 when a user is locking it for editing etc and 0
when
the lock has been commited etc...
_____
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: 18 February 2004 00:02
To: SQL
Subject: RE: Locking Records
Sorry,
When I mean the same time I don't mean it as a precise time frame.
For example, I have one user who wants to make changes brings the data
up,
then sits on it for awhile. The user B comes along opens the data, but
because User A has it already I want to prohibit user B from saving this
back to the database.
Is it possible to lock it this way...
Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
_____
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, 17 February 2004 8:52 PM
To: SQL
Subject: RE: Locking Records
Both ways will work. There are several ways you could lock a record -
you
could use as you mentioned : cftransaction but there are granular levels
of
control in say SQL Server which allow greater locking - SQL Server by
default locks anyway so its actually impossible for a users to edit
records
at the same time.
_____
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: 17 February 2004 04:57
To: SQL
Subject: Locking Records
Is it possible to lock a record, so that another user can not edit
delete
this until you are finished with it.
I was using cftransaction with a cflock that had the same name if it was
an
update or delete, hoping that if one user tried to read this while I was
editing it or updating it that it would not return until the lock had
finished.
Would this work, or would it be best to handle it with SQL....
Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
_____
From: David Brown [mailto:[EMAIL PROTECTED]
Sent: Saturday, 20 December 2003 3:03 AM
To: SQL
Subject: DTS package
I have a pipe delimited text file (17 columns) with LF as the row
delimiter.
One of the files that I need to import is over 56 megs. I have tried
DTS to
import the file, but get around 1000 rows per second.
Is bulk copy the best or just straight import through a dts package?
I am looking for the fastest way to import it. After 4 min I had 86000
rows
out of about a million.
David
----- Original Message -----
From: Antony Sideropoulos
To: SQL
Sent: Thursday, December 18, 2003 8:49 PM
Subject: Re: multi-step SP
What's wrong with sp_ ?? I thought I was quite clever using that as
my
prefix?
:-(
>From: "Neil Robertson-Ravo - Team Macromedia"
><[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: SQL <[EMAIL PROTECTED]>
>Subject: Re: multi-step SP
>Date: Wed, 17 Dec 2003 21:11:46 -0000
>
>Hey Michael,
>
>Do you want this variable to be passed around from within an sproc
itself
>or out from an sproc into another SP? It sounds and looks as though
you
>can do the whole shebang in one SQL query/sproc.
>
>You can also set a variable in the SP can call it via:
>
>usp_yourproc @input , @result output
>
>where @result is defined and set inside the sproc.
>
>Are you planning to use cfstoredprocedure or EXEC within a cfquery
block?
>
>Also, remember and NOT to name your sproc "sp_" as that will degrade
SQL
>Server performance on your db operations.
>
>
>
>
>
>----- Original Message -----
> From: Michael Dinowitz
> To: SQL
> Sent: Wednesday, December 17, 2003 7:33 PM
> Subject: multi-step SP
>
>
> I've got a massive uploader where the data (after mapping) is put
into
a
>temp
> table and then has to be transformed some and put into 2 live
tables.
I
>need to
> do the following queries:
> 1. get lastid+1 from items table
> 2. generate parent/child relationship for item
> 3. put tempitem into items table
> 4. put tempitem into lotmatrix table
> 5. delete temp item
> These have to be done in a one at a time fashion and is a lot of
>queries. CFMX
> doesn't like 1500+ queries inside a CFTRANSACTION block (I'm
assuming
>that's the
> source of the error as it works) so I have to do the whole
operation
one
>at a
> time.
> Does anyone have the syntax offhand for assigning variables from a
query
>in an
> SP to another query in an SP? I want query 1 in the SP to get the
lastid
>and
> store it as a var. Query2 in the SP will then use that var with
others
>to
> insert.
> Thanks
> --
> Michael Dinowitz
> Finding technical solutions to the problems you didn't know you
had
yet
>
>
_____
_____
_____
_____
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
