Has anyone else noticed this?
I thought it might just be the one setup which has many many backups and its checking though them but is same on my dev laptop which only has maybe a dozzen backups.
This has sat like this for about 5 minutes now;
I’ve had it in the last, not for that long. My laptop takes a few seconds to load but it takes longer the more backups there are
Hmmm, just noticed there is a gapp there too, 9th jumps to 13th…
Something funky happening
Slow loading depends on the amount of backups you have because it needs to read the description from inside every zip file (each file contains a desc.txt file with the description, even if you don’t set a description it will need to check for its existence).
On my desktop computer, first load of Database Backup takes about 20 seconds. Subsequent loads are immediate so assume some of the data to display is cached.
Given the size of your backups from your other post about 270Mb zipped if I recall, I would suspect that would also slow down the process of checking the descriptions.
I can’t say I can remember if older versions had this delay or not, it’s always happened as long as I can remember and I appreciate the reason why. Just move some older backups out of the backup folder and it will resolve.
2 Likes
Sorry missed that part. I think it’s possibly due to the size of your backups then, are those on your dev laptop also 270Mb in size?
Ive moved them into a archive subfolder.
That smaller one didnt like being moved so perhaps corupted and causing issue loading the list.
Is fine now ive move 99% of them to an archive folder and deleted that smaller one.
That means it is still open. Restart the system should resolve.
1 Like
You moved %99 to another directory and it still slow. Is that correct?
It was that smaller one, think it was corrupt or something as wouldn’t move, deleting that. If put others back it’s still a little slow to load but as said it has to look into the zips so qty will be a factor but no longer minutes as before.
1 Like
I had same issue,
It was due to cloud drive not fully sync. I deleted a load of the files and then when I went to show the databases the folders didn’t match and so windows was synching the files. That’s what slowed samba because it was waiting to show the files that hadn’t syncd
Of that makes sense?
I had a progress bar that, when complete, all of a sudden it showed the backups within samba
Sorry for hijacking the thread, but if my backups are more than 1 GB, is that bad?
Mine does that but it’s because it’s on onedrive and it’s downloading them.
Your zipped backup should not be 1Gb in size. I think there must be something seriously wrong with your setup. What size is your database?
Can you run a report to show the table size in SSMS. Right click database, select Reports > Standard Reports > Disk Usage by Table.
On the report, click the sort on the Data (KB) column to sort descending, showing the largest size at the top, then paste a screenshot of the results here.
Thats an impressive number of tickets;
Interesting how your orders table is not hugly larger for allot more ticket but expect thats because I have a large number of order states.
Tasks seems pretty big for the number of records in comparison to other tables but guess they are likley storing allot of data.
I got have much use of tasks on this system to compare but most tables seem comparable for the number of records.
What are you storing in tasks ? That is a huge proportion of data to records. 3 million account transactions and it’s less than half of your tasks which is only 92k
The only thing I use Tasks for is from this tutorial.
Isn’t the max for SQLExpress 10 GBs? Should I be worried?
Yes you should probably upgrade to paid full SQL server or reduce it
So, if I go for the “Standard - per Core” route, I would have to shell out $14,868.00 for a 4-core computer.
If I go for the “Standard - server + CAL” route, it would only be $3,724.00, but I would have to pay extra for each terminal I decide to add on in the future.
Is this something that SambaPOS users will face eventually?