Slow performance

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.

1. In Store Operations Administrator on the File menu, click Connect. This will open the Connect to Server window.

1. Type , click Use SQL Server authentication, type , type , select the correct Store Operations database name and then click OK.

2. On the Query menu, click New to bring up the New Query window.

1. Type the statement below and press the F5 key to execute:

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]

1. Repeat step 3 and type the following query and press F5 to execute:

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: