The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Working with lock up correctly? I am using Delphi with ASA 9.0.2.3951. The times of some customers complain about "locking" system. Analyzing the db, I realized that each select effected the tables involved are being blocked (see call sa_locks ()). The tables listed in sa_locks procedure may influence the performance of the database?

asked 21 Jan '14, 12:22

Walmir%20Taques's gravatar image

Walmir Taques
600283143
accept rate: 13%

edited 21 Jan '14, 12:44

Justin%20Willey's gravatar image

Justin Willey
6.4k101132197

Just out of curiosity, what version of Delphi are you using?

(22 Jan '14, 09:43) JBSchueler
Replies hidden

We use Delphi version 5.0 (build 6.18) Update Pack 1, some old projects. And those projects that are "locking".

(22 Jan '14, 09:53) Walmir Taques

A lot will depend on what isolation level you are using. Have a look at this in the docs, but be aware that this link is for v10.0.1 - you are on the even older v9.0.2 which did not support Snapshot Isolation

In general you should use the lowest isolation level that is consistent with your needs for preserving the consistency of the data presented to users. Using high isolation levels will certainly have an effect on the concurrency of your application ie you will get locking.

permanent link

answered 21 Jan '14, 12:43

Justin%20Willey's gravatar image

Justin Willey
6.4k101132197
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×95
×17
×10
×4

question asked: 21 Jan '14, 12:22

question was seen: 557 times

last updated: 22 Jan '14, 09:53