Dear All,
we have been using Samba POS V5 for two years using SQL database.
Now, Samba POS response time is getting slower than before.
When i checked “Ticket Transactions” , it is over 90000 ticket transactions.
Please, anyone suggest me how to maintain those transaction?
Or Is it possible to move out yearly sale transactions from current database?
Someone, please help me.
Respected,
MD Hasan
In theory if your not using allot of reporting expressions in button headers or entity screens a large DB should effect normal operation. Although like you I too feel that it does have an impact eventually as clearing transactions seems to speed things back up again.
Simplest solution is to either backup and clear transaction history with the database task. You have the backup should the need come up to go back.
Another solution which I usually use is to either start a new database and restore backup but clear transactions meaning there is a database backup you can change back to which is slightly more conveniant if you have to look back allot as can just change connection string for office machine or whatever.
There is however no real method to only part clear history, on a single active DB.
When I have cleared out or started fresh I have done so on a logical date like a stocktake or end of a financial period.
In theory in SQL Server this should not happen. There should not be any noticeable reduction in transaction response time no matter you have 10 or 1 million transactions stored.
It could be related to the database indexes, you can try to go to Settings > Program Settings > Maintenance and select “Rebuild Indexes”.
This should improve database transaction speed.
Also, to reduce SQL Server memory usage, you can also run “Auto Size” and select “Safely Auto Size” from the same screen. This will reduce the memory required to handle text records in the database and you should notice an improvement after doing this. I usually recommend using “Auto Size” on all systems as it can improve performance even significantly on some systems.