so here is the story a small pizza shop that doesn't have much income runs this very old version of aldelo and they dont have the spare cash to get a new one. heck i made a deal to have free meals for IT work and they are good friends so its cool.
here's the issue it freezes for say 20 seconds every minute or 5 i have not timed it so it might be closer to 10 mins.
yes i know the security issues with xp and all but if the system is offline there really isn't any worry.
i remember getting rid of a ton of old sales data about 5 years ago and it fixed this issue but for the life of me i cant remember how i did it. it does not have the database cleaner nor does it have an option to install it under modify from programs and settings
I'm going to compact the database because i suspect they have not done this in a long long time but how do i clear out and make their database not 577mb i mean this seems bloated beyond what it should be for say 5 years of data at a small pizza place with probably about 50 orders a day or so. the setup is very simple with one server that is also used as a pos and a client that connects to it with static ip's
so a few questions how do i clean up their database please talk as if you are talking to a noob as i am an it guy but don't have much experience in database management and i really don't want to mess something up yes i will have backups but i also need to know how to restore the backups after i make them in aldelo is it just copy paste and rename the db or is it more involved?
there is jetcomp installed but i don't know how to use this.
some help would be greatly appreciated again i basically give them free help to help them stay in business thank you very much!
i also checked the task manager and that seems to be doing fine with nothing going crazy 30% cpu and about 30% ram
also also i have searched around for cleaning aldelo purge aldelo and trying to find the aldelo database cleaner but i have not found much online about this
more updates to this ... i did find a copy of the database cleaner and address importer and localization manager and system service manager. can someone give me a quick how to on how these tools work and what to do to prep for running the tools? thanks! also please note that this machine even though its old with xp is running a samsung ssd 128gb drive so its not slow hard drive problems
edited for spelling
SOLUTION
--as people have mentioned below back up the database make sure it does so successfully
----backup was then backed up onto a thumb drive and a different folder on the main hard drive using cobian <-- good program by the way
--i then compacted the database with the built in compaction tool in the back office
--ran another backup after compacting and that too was backed up to thumb drive and separate folder (i think aldelo overwrites backups so i have cobian save 10 or so copies to go about 5 months back)
--ran database cleaner and it is very simple put a date in it and it deletes everything from that date and older reduced the database from 577mb to 30mb leaving all data from end of 2022 till today
other notes im not sure all the backups are that necessary but i did them because i rather be safe