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: Thursday, 19 February 2004 8:36 PM
To: SQL
Subject: RE: SQL server timing out
Many things can contribute to SQL Server timing out.....do you have any
TRANSACTION blocks around any update/insert statements etc? Are you
running CFTRANSACTION around queries..... are you running loads of SELECT *
on tables?
Its difficult to see why it would be locking without knowing your schema
etc...
Try run a SQL Profiler Trace and you will see what queries are taking too
long and if they need to be amended.
HTH
N
_____
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: 19 February 2004 00: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]
