We have been running RMS Store Operations since Feb 2004. We now have more than 100,000 sales transactions, 4500 purchase orders, 10,000 customers and
9000 inventory items. (We're on 1.20161, as we are a single store, and there seemed to be little advantage to the 1.3 upgrade for single location users who do not run HQ.)We run 2 POS on two lanes. One acts as the server where the database resides. We are running the SQL Server tha comes with Windows XP. We also run Store operations on 3 or 4 other stations. Most stations have 512 MB of RAM including the "Server."
Users have complained the system slows down under certain conditions. For instance, the first credit card transactions of the day are always slow to authorize. Looking up a receipt in the journal can take more than a minute. On the other hand, product and customer lookups are fast.
We have considered several ideas to speed up performance. I am interested in your collective wisdom as to which of these actions might actually improve performance.
- Add RAM to the server
- Install the database on a dedicated server
- Archive transactions more than 13 months old
- Upgrade our Linksys router to something more industrial
Any thoughts?