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
690374151
accept rate: 12%

edited 21 Jan '14, 12:44

Justin%20Willey's gravatar image

Justin Willey
7.6k137179249

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
7.6k137179249
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:

×108
×21
×13
×4

question asked: 21 Jan '14, 12:22

question was seen: 2,069 times

last updated: 22 Jan '14, 09:53