X-Cart forums

[Chheang Leng]

Hi x-cart team!

Now my site have slow I thinking then by directory var. In this directory have many directory run,run1,.......run10. How can I delete some directory run1,.....run10.? I think this directory not important .

[qualiteam]

I believe run1, run2, and so-on directories were created manually (perhaps, for back-up reasons). You may delete them if you don't need them anymore.

But you should not delete the var/run directory that stores "compiled" X-Cart scripts. To refresh this directory please use the "Re-deploy the store" link in your back-end.

[Chheang Leng]

Hi x-cart team!

site have slow i thinking have file in site make the slow web site. Are you know how to fix it or why it slow?

[qualiteam]

Unfortunately, it is almost impossible to guess why this may happen. You need to find someone who could check the problem right on your server. Please contact our support staff (https://secure.x-cart.com/) if you want us to investigate the issue on your server.

[tony_sologubov]

As a first step of investigation performance-related problems, please enable the Webmaster Kit module and enable profiler in its settings. You will be able to see MySQL-related bottlenecks on the problem pages then.

Please, let me know if it helps.

[Chheang Leng]

Hi x-cart team!

this is an report at file sql.log.2014.09.04

[02:46:38.000000] Query #1: SELECT t0.moduleID AS moduleID1, t0.name AS name2, t0.author AS author3, t0.authorEmail AS authorEmail4, t0.enabled AS enabled5, t0.installed AS installed6, t0.yamlLoaded AS yamlLoaded7, t0.date AS date8, t0.rating AS rating9, t0.votes AS votes10, t0.downloads AS downloads11, t0.price AS price12, t0.currency AS currency13, t0.majorVersion AS majorVersion14, t0.minorVersion AS minorVersion15, t0.minorRequiredCoreVersion AS minorRequiredCoreVersion16, t0.revisionDate AS revisionDate17, t0.packSize AS packSize18, t0.xcnPlan AS xcnPlan19, t0.moduleName AS moduleName20, t0.authorName AS authorName21, t0.description AS description22, t0.iconURL AS iconURL23, t0.pageURL AS pageURL24, t0.authorPageURL AS authorPageURL25, t0.dependencies AS dependencies26, t0.tags AS tags27, t0.fromMarketplace AS fromMarketplace28, t0.isLanding AS isLanding29, t0.landingPosition AS landingPosition30, t0.isSystem AS isSystem31, t0.hasLicense AS hasLicense32, t0.editionState AS editionState33, t0.editions AS editions34 FROM xc_modules t0 WHERE t0.enabled = ?
Parameters:
true
Duration: 0.0005sec.
Doctrine UnitOfWork size: 365
Runtime id: 5585a5a267831563ff387eb03f19edb1
SAPI: cgi-fcgi; IP: 103.23.136.8
URI: /admin.php?target=module&moduleId=183
Method: GET
Backtrace:
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 717
file <X-Cart root>/lib/Doctrine/ORM/EntityRepository.php : 179
file <compiled classes repository>/classes/XLite/Model/Repo/Module.php : 738
file <compiled classes repository>/classes/XLite.php : 401
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 148
file <compiled classes repository>/classes/XLite/Controller/Admin/Module.php : 55
file <compiled classes repository>/classes/XLite.php : 417
file <compiled classes repository>/classes/XLite.php : 442
file <X-Cart root>/admin.php : 37

[02:46:38.000000] Query #2: SELECT t0.enabled AS enabled1, t0.id AS id2 FROM xc_roles t0 INNER JOIN xc_profile_roles ON t0.id = xc_profile_roles.role_id WHERE xc_profile_roles.profile_id = ?
Parameters:
4
Duration: 0.0033sec.
Doctrine UnitOfWork size: 377
Runtime id: 5585a5a267831563ff387eb03f19edb1
SAPI: cgi-fcgi; IP: 103.23.136.8
URI: /admin.php?target=module&moduleId=183
Method: GET
Backtrace:
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 862
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 801
file <X-Cart root>/lib/Doctrine/ORM/UnitOfWork.php : 2584
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 218
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 524
method Doctrine\ORM\PersistentCollection::count()
file <compiled classes repository>/classes/XLite/Model/Profile.php : 777
file <compiled classes repository>/classes/XLite/Core/Auth.php : 665
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 79
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 57
file <compiled classes repository>/classes/XLite/Controller/AControllerAbstract.php : 458
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 153
file <compiled classes repository>/classes/XLite/Controller/Admin/Module.php : 55
file <compiled classes repository>/classes/XLite.php : 417
file <compiled classes repository>/classes/XLite.php : 442
file <X-Cart root>/admin.php : 37

[02:46:38.000000] Query #3: SELECT t0.enabled AS enabled1, t0.id AS id2, t0.code AS code3, t0.section AS section4 FROM xc_permissions t0 INNER JOIN xc_role_permissions ON t0.id = xc_role_permissions.permission_id WHERE xc_role_permissions.role_id = ?
Parameters:
1
Duration: 0.0004sec.
Doctrine UnitOfWork size: 378
Runtime id: 5585a5a267831563ff387eb03f19edb1
SAPI: cgi-fcgi; IP: 103.23.136.8
URI: /admin.php?target=module&moduleId=183
Method: GET
Backtrace:
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 862
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 801
file <X-Cart root>/lib/Doctrine/ORM/UnitOfWork.php : 2584
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 218
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 568
file <compiled classes repository>/classes/XLite/Model/RoleAbstract.php : 107
file <compiled classes repository>/classes/XLite/Module/CDev/UserPermissions/Model/Role.php : 56
file <compiled classes repository>/classes/XLite/Model/Profile.php : 779
file <compiled classes repository>/classes/XLite/Core/Auth.php : 665
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 79
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 57
file <compiled classes repository>/classes/XLite/Controller/AControllerAbstract.php : 458
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 153
file <compiled classes repository>/classes/XLite/Controller/Admin/Module.php : 55
file <compiled classes repository>/classes/XLite.php : 417
file <compiled classes repository>/classes/XLite.php : 442
file <X-Cart root>/admin.php : 37

[tony_sologubov]

Hi Chheang!

This is not quite what you need.

1) Enable profiler in the Webmaster kit module.
2) Go to the slow page and you will see report at the bottom of this page. It will look like this: http://awesomescreenshot.com/0433fkgec1
3) Check reference points and if there is any red records (you note them), please let me know about them. Alternatively, you can make the snapshot of entire page (services like awesomescreenshot allows to do that) and send it to me.

Tony.

[Chheang Leng]

Hi x-cart team!

I thinking it slow by directory run and some directory run(run,...run14) not important . In the directory var have many directory run (run, run1,.......run14). At the directory run have size 9MB.
this is an report queries log

[tony_sologubov]

Well, benchmark shows that working time is 1.7 sec, which is not very good, but not that bad either.

I feel, you might want to change hosting account in order to allow X-Cart 5 work smoothly, because at this point X-Cart 5 seems to not have dramatical problem.