Any time I want to void the transaction on version 2.00 It takes too long to find the transaction. It takes more than 2 minutes. (tab F11 void a transaction) Is there Any solution to spped up.
- posted
14 years ago
Any time I want to void the transaction on version 2.00 It takes too long to find the transaction. It takes more than 2 minutes. (tab F11 void a transaction) Is there Any solution to spped up.
Harjit,
We had a problem that appears to be similar to yours. We are also a market and have many transactions per store per day. It seems that with a large number of transactions in the database the recall to void a transaction becomes very slow.
The key to solving the problem in our case was to create a better indexing scheme on the transaction table.
RMS Support sent us the following instructions to create additional indexes on the transaction table...
From the support technician: After some research I found a previous incident where the development team was consulted and they provided the following step
To fix this problem try these steps.
create CLUSTERED INDEX [Transaction1] ON [dbo].[Transaction]([RecallType]) ON [PRIMARY]
Then repeat step 3 and type the following query and press F5 to execute the query:
CREATE INDEX [Transaction2] ON [dbo].[Transaction]([Time], [RecallType]) ON [PRIMARY]
UPDATE STATISTICS [Transaction] WITH FULLSCAN
If this does not fix the problem I suggested running the following two SQL Statements:
DELETE DEX_LOCK DELETE DEX_SESSION
Best Regards, James B.
"Gill" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.