SmartCJ Support Forum

Hello,

I updated to latest version.

When not cached, my site and access to the admin is loading slow because it has a lot of galleries to the database.

When connecting to scj/admin/ it sometimes go to 504 Gateway Time-out after loading for a while.

1) I see you can optimize database in scj admin. I would prefer to do it through ssh. What command should I type?

2) Is there anything else I can do to make the site load faster? It's on a good dedicated server.

ps: You have access to the admin in the pm.

Thank you.

Hello,

optimize in admin area won't help in this case

did you check server LA?
what process consumes the most resources and so on?

Server LA is about 4. Mysql is taking most of the usage.

Also after update. When I go to https://www.domain.com/scj/admin/?operation=main&sub=& I get this error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 67108872 bytes) in /data/domain.com/html/scj/includes/libs/check_scj.lib.php on line 134

You have access to the admin in the pm.

Thank you.

looks like you have a lot of extra files in scj folder
can you please check on ftp what files you have in that folder?

I just have in scj folder:

ioncube_fallback.php
scj2.free.lic
sitemap.php
scj2.sql
scjwebmaster.php
rotation.log
rss.php
scj2.lic

and subfolders

I really think the problem is mysql. The database has 3 millions galleries and the db size is 27 gb which is huge.

ok, send ssh plz