| Re: Best way to process large volume of data (Oracle9i) [message #23112] |
Mon, 18 November 2002 16:06 |
Andrew G.
Messages: 7
Registered: November 2002
|
Junior Member |
|
|
It's a business reason, sorry I wasn't very specific about it, and it is a database lock. The accounts are trading accounts and the new records are transactions. A lot of validation is based on the credit limits and similar things, which are kept on the trader account level or on some system defined levels.
Anyway, the issue is that the system should be able to handle both online and offline (imported) transactions and because of these online transactions I need to lock their accounts as I have to make sure that the system authorizes them 100% correctly. I know it's a bit complicated but I'm just a poor IT developer...
So what I need to lock at the trader account is the credit balance, so that if any online transaction comes in at that time it can't access the account.
Andrew
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
