Product Version:

iVend 6.5.6

Problem statement:

The customer has started facing the issue while printing the transaction receipt at their stores. Initially the transaction receipt was taking 2-3 seconds but after sometime it started taking 12 seconds or more.

Cause:

There were 2 cause for this issue:

1. The provided custom transaction receipt query was not optimized, and

2. The customer was using SQL EXPRESS edition at their stores where the space utilization for the SQL was 9600 MB (9.6GB / 10 GB max limit from Express edition)

Resolution:

To fix the issue following has been done:

1. The report team provided the optimized query with the report, and

2. The customer purged the data from the stores to create the space in SQL EXPRESS edition.

After performing above 2 steps, the issue has been resolved at customer with the required performance.