Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: Post taking over 2 minutes on a single reccord edit.



Permlink Replies: 3 - Last Post: Jun 2, 2017 7:44 AM Last Post By: John MacDonald Threads: [ Previous | Next ]
John MacDonald

Posts: 179
Registered: 3/22/98
Post taking over 2 minutes on a single reccord edit.
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 27, 2017 5:05 AM
I have a database of calls in a contact manager.

I pick one of them, open a new form and complete the edit. " No Problem"

The next line fires off a post, updates the display and done.
I've done this many times now. BUT
This time it takes almost 2 minutes to complete the post.

Even the monitor seems to reset during the search.

There is a primary key on the database and two other fields that are part of the indices.

What could make a simple post go on and on for this amount of time?

--
JMAC out

Jeff Overcash (...

Posts: 1,416
Registered: 9/23/99
Re: Post taking over 2 minutes on a single reccord edit.
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 27, 2017 5:04 PM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
I have a database of calls in a contact manager.

I pick one of them, open a new form and complete the edit. " No Problem"

The next line fires off a post, updates the display and done.
I've done this many times now. BUT
This time it takes almost 2 minutes to complete the post.

Even the monitor seems to reset during the search.

There is a primary key on the database and two other fields that are part of the indices.

What could make a simple post go on and on for this amount of time?

--
JMAC out


Deadlocks in a wait transaction state would cause it since you are editing a record.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Post taking over 2 minutes on a single reccord edit.
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 28, 2017 9:21 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Sorry, what do you mean?

I open and edit,; what must I do before posting?

I'm using firedac and internals. In vase I left that out.


Jeff Overcash (TeamB) wrote:
John MacDonald wrote:
I have a database of calls in a contact manager.

I pick one of them, open a new form and complete the edit. " No Problem"

The next line fires off a post, updates the display and done.
I've done this many times now. BUT
This time it takes almost 2 minutes to complete the post.

Even the monitor seems to reset during the search.

There is a primary key on the database and two other fields that are part of the indices.

What could make a simple post go on and on for this amount of time?

--
JMAC out


Deadlocks in a wait transaction state would cause it since you are editing a record.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

--
JMAC out
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Post taking over 2 minutes on a single reccord edit.
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jun 2, 2017 7:44 AM   in response to: John MacDonald in response to: John MacDonald
I see many people have looked at this thread.

The issue is solved.

I had a select * list in a grid. This can not be updated directly, very well.
A query with a primary key parameter is used for the edit.

I had to shut down the original query fir the list and open it after.

Now things are working much better.

I'm sure we will not be using these old methods of edit and update at some point. For now because we are trying to complete our data migration with very little code change then we must make due.

Thanks for the help.


John MacDonald wrote:
I have a database of calls in a contact manager.

I pick one of them, open a new form and complete the edit. " No Problem"

The next line fires off a post, updates the display and done.
I've done this many times now. BUT
This time it takes almost 2 minutes to complete the post.

Even the monitor seems to reset during the search.

There is a primary key on the database and two other fields that are part of the indices.

What could make a simple post go on and on for this amount of time?

--
JMAC out


--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02