If you have a support question or comment, click the Post New Topic link below. Sytist Manual | Sytist Articles | Facebook Page.

Management Interface Speed

 
Please log in or Create an account to post or reply to topics.
 
Michael Weeks
208 posts
Fri Feb 09, 18
3:06 PM
My management interface seems to be getting ever more slower (customer side seems OK) I wondered if this may be down to my database size which is approx 600MB, a slow database server (which I cant find a way to diagnose) or something else
Michael Leenheer
276 posts
Fri Feb 09, 18
5:11 PM
I had an issue with this when my storage on my server was over 90% full. Not sure if that's your issue but if you are running out of hosting space it will cause problems.
 
 
 
 
 
Michael Leenheer | New Light Photography - SUB Photo
Michael Weeks
208 posts
Fri Feb 09, 18
5:33 PM
Unlimited hosting (or so they say) so should not be that problem.

Mike
Bill Wells
243 posts
Sat Feb 10, 18
10:37 AM
Unlimited hosting, is really NOT unlimited.

They say unlimited disk space and that part is true. However, they will have limits on the total number of files and CPU/memory limits. Going over any of these limits could affect performance. In the example of CPU/Memory, most just throttle your speed until things slow down.

As far as disk space. Let's say you have unlimited disk space, you could have 100files = 4tb and be fine. However, you can not have 125,001 files = 25gb. *125,001 represents 125,000 file limit.
 
 
 
 
 
-Bill Bill & Jessica Photography https://wellsandcarnes.com
Tim - PicturesPro.com
9996 posts
admin
Sun Feb 11, 18
6:05 AM
Here are some things that might help speed it up.

Go to Stats -> Shopping Carts. Delete older abandoned shopping carts.

Delete old galleries that are not needed.

Go to Settings -> Backup Database and do the optimize database.

Click Stats in the main menu. This will compile old stats and reduce the rows in the stats table.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Michael Weeks
208 posts
Tue Feb 13, 18
5:34 AM
I can not delete old galleries unfortunately. I regularly optimise the database, I only have a handful of shopping carts as i regularly purge, I have gone to the stats page.

i have been in touch with the webhosts and in no way am I having an issue with unlimited hosting.

Customer side seems OK

It is however still slow

Mike
Tim - PicturesPro.com
9996 posts
admin
Wed Feb 14, 18
4:37 AM
It is just probably due to the amount of data in the system unless the database server is being slow. I am always looking into ways to speed things up when working on updates.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Michael Weeks
208 posts
Wed Feb 14, 18
4:51 AM
I am looking at upgrading hosting as well to see if that has any advantages

Mike
Tim - PicturesPro.com
9996 posts
admin
Wed Feb 14, 18
9:35 AM
Something you can try that I have seen work in the past since you have had it installed for a long time is (though will take some work):

1) Create a new MySQL database & user in your hosting control panel.

2) Go into the PHPMyAdmin, select your current database and export it as a file.

3) Go into the new database you created in PHPMyAdmin and import that exported file.

4) Edit your sy-config.php file either through the file manger in your hosting control panel or download via FTP and edit in a text editor like notepad and update it with the new database name, username and password.

This will be a new database and possibly on a newer version of MySQL.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Michael Weeks
208 posts
Wed Feb 14, 18
1:19 PM
Tim,

tried that and no success

many thanks for the input

Mike Weeks
M Davis
250 posts
Wed Feb 14, 18
7:08 PM
I have a Sytist site on 1and1 hosting unlimited.
I manage another Sytist site for someone else on Saratoga Hosting.
The Saratoga admin access is like driving a high-performance sports car compared to the 1and1 hosted site.
Safe to say it is your hosting company!
 
 
 
 
 
M. Davis
Michael Weeks
208 posts
Thu Feb 15, 18
3:10 AM
M davis, how large are the databases on those sites?
Michael Weeks
208 posts
Tue Mar 06, 18
4:40 AM
So I bit the bullet, upgraded hosting and had a lot of issues, many of which could have been avoided.

1. I had set up and tested Amazon S3 but only transferred 1 gallery
2. This meant about 800,000 images occupying approx 250GB of spaces
3. A database of nearly 600KB
4. A database backup would take anything like 6-10 minutes

Whilst i had unlimited hosting the web server was on one part of their system and the database server on another

Changing to an SSD VPS would mean both services co-located and therefore much faster

1. A VPS is limited capacity and the bigger the more expensive

Solution

1. remove unnecessary galleries (not immediately required)
2. move as much as possible to S3
3. re-upload galleries as required

The database reduced to about 200 KB but still took about 2 minutes to create a backup before transfer
After transfer it is almost instantaneous

Now to start adding those galleries back
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2017 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close