Long Insert/Update Time

[ajmcgee]

Hello all,

The hospital dietary program I am writing is working well in most respects. I am having a problem concerning the insert/update time.

When I attempt to complete a transaction the program is to function as follows;

1. Update TRANSACTION record with transaction details.
2. Update USER record with new acct balance
3. Insert 1 to 4 TRANSACTION DETAIL records detailing accounting debits and credits.

All of this seems to be working but takes between 7 and 22 seconds to complete as illustrated with data from the RB Console below;

192.168.122.145: seaside POST/seaside/go/runbasicpersonal -> 302 Text/html



Web Hit
Hit Rcvd: June 22, 2011 16:51:28.000
Turnaround (ms): 2628

Web Answer
Status: 302
Reason:

I have thought about using Begin Transaction/Commit Transaction to see if this would speed things along. Any other ideas?



I just realized this post maybe should be in the Database discussion. If this is a true statement would a moderator please move it to the appropriate area.


Thanks, Alan

[kokenge]

Without knowing what your DB looks like or how large it is, it's hard to tell.
However to insert 5 records or less should not even be noticed.

There is something else going on..
Could be a loop in your code.
You could be looking up data in a huge table without a index.
You could be doing a update and the WHERE needs an index.
Could be almost anything..
If it's possible to post your code and db schema it would help..

[ajmcgee]

Thanks Dan,

I'll post the DB later today.

Alan

[trenatos]

Did you figure this out?
What was/is the issue?

[ajmcgee]

Sorry for the delay.

I moved the program to a corporate file server (zeon?) and the problems went away. When I use my local computer or a computer on my local network the problem is still very much a problem.

A side note. Since moving the program to a server, my error rate has been zero. No file locking errors or any other database errors.

I hope this helps,

Alan