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
Very Slow Transaction Post
Apr 01, 2009
1 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required