My POS station has become incredibly slow to post transactions and print the receipt. The database has grown to about 2gigs. Any suggestions?
Thanks
Scott
- posted
15 years ago
Very Slow Transaction Post
Loading thread data ...
- Vote on answer
- posted
15 years ago
Hi Scott
Normally we find that growth is mostly due to the journals. I would recommend that you thin them out a bit, say removing anything older than a year. You could use the below command for it:
DELETE Journal WHERE time < getdate()-365
The above statement will delete all journals over 12 months old (alter the number of days as required)
and then run this SQL statement
dbcc shrinkdatabase DatabaseName