Thanks for the help,
I'll have a word with our DB Admin.
Jason Lees
National Express Ltd
E-Mail : [EMAIL PROTECTED]
-----Original Message-----
From: John Forrester [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 11:15
To: CF-Talk
Subject: Re: Deadlocks in Ingres
Part of your problem is related to where you place the locks in order to
read or modify. We have similar problems with some old code relating to
updating population changes. The locks are placed at the table level. Result
is a deadlock when too many transactions arrive.
Aside from changing the code you play a little with systems factors like the
fill factor. If locks arrive at a page level, you could config the system to
fill at a reduced rate for each page in order to lock out fewer records. The
way the DB is organized can also be important.
A good place to start with for suggestions etc. would be:
http://www.cs.mu.oz.au/~yuan/Ingres/ingres.html
Playing with fill factors etc need to be understood well - particularly if
you don't have another db system to experiment with.
dott. John Forrester
Senior Networking e Systems Engineer
Ancitel Spa
Tel: +39-06-76291206
Cell: +39-0348-7972041
Fax: +39-06-76291328
email: [EMAIL PROTECTED]
----- Original Message -----
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 11:33 AM
Subject: OT : Deadlocks
>
> Hi All,
>
> Our system appears to be generating a lot of Deadlocks when using SELECT,
> how can I get round this, I have <cftransactions> around the select with
the
> BEGIN and READ-UNCOMMITED options set.
>
> The DBMS that we are using in Ingres, and calling through an ODBC
> connection.
>
> Any one have any Ideas about how to resolve the deadlocks?
>
> All help gratefully received.
>
> Jason Lees
> National Express Ltd
> E-Mail : [EMAIL PROTECTED]
>
> ###################################################
> This document is intended for, and should only be read by, those persons
to
> whom it is addressed. Its contents are confidential and if you have
received
> this message in error, please notify us immediately by telephone on 0121
609 6301
> and delete all records of the message from your computer. Any form of
reproduction,
> dissemination, copying, disclosure, modification, distribution and / or
> publication of this message without our prior written consent is strictly
> prohibited. Neither the author of this message nor their employers accept
> legal responsibility for the contents of the message. Any views or
opinions
> presented are solely those of the author.
> If you have any queries please contact [EMAIL PROTECTED]
> ####################################################
> ##################################################
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
