Storefront is too slow!

[panski]

Hello Abantecart!

I have been using your services for nearly 2 years now. Throughout this time I've been experiencing one big issue which is website loading.
Poor website opening results in 25-30% decrease in customer and order rate which is not a good thing for sure!
Not once I tried to contact your customer support. Everytime there is one answer: "check your hosting". My hosting has nothing to do with this problem.
Here are the details of my host:

VPS
Intel® Xeon® E5-1650 v2 - 4 x 3.6GHz
RAM - 6 GB
Data transfer - Unlimited
Disk storage - 120 GB

Details about my AbanteCart:

Version - 1.2.4
No. of orders - 6,767
No. of registered customers - 5,701
No. of products - 1,729

Storefront URL: https:// mantis.ge/mantis/

Based on the forum topics, it seems that I'm not the only one who is experiencing this issue.
If there is no way for the website to load faster, I will need to switch to another engine (reason stated above).

Regards.

[abantecart]

Do you have cache enabled? Did you apply any web server compression?

PM if you like us to analyze your site and hosting.

FYI. Many things are related to hosting as most performance tuning is on the server side. We do not neglect optimization of the application itself and you can see this from the below

NOTE: Version 1.2.5 and 1.2.6 had some improvements and extended .htaccess to boots server optimization
Additionally, upcoming version 1.2.7 will have significant improvement in in performance with more options for caching and tuning based on AbanteCart PHP profiling

[eCommerce Core]

I am interested to know what can cause slow performance and if this has been already addressed in newer versions.

Before you try to upgrade, try to enable debug in admin (with SQLs) and save it to the log.
Check the result and see what takes long time.

What is very common in SQL side, for example, is related to broken index on Mysql database. You can run a maintenance check for this:
http://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html

[panski]

Everything works fine when I install clean copy of AbanteCart. However, once I import the database, boom - it starts lagging again.
I would greatly appreciate your help. Please PM me for server details.

Regards

[eCommerce Core]

Everything works fine when I install clean copy of AbanteCart. However, once I import the database, boom - it starts lagging again.
I would greatly appreciate your help. Please PM me for server details.

Regards

This is an indication that might have issue with Mysql tables after import.
1. Try to run database table maintenance.
2. check version 1.2.5 and 1.2.6 install/..upgrade.sql or install/..upgrade.php for new table indexes. Apply them in your database. 
This might help.

[panski]

I should say that admin panel loads just fine. The problem is with storefront.
Once again, I would greatly appreciate any help; so if anyone is willing to figure out what's going on - please PM me.

Regards.,

[panski]

Guys, once again I ask you to provide some kind of assistance to resolve this issue. Side admins are welcome to PM me in order to have any requisites necessarry to handle this problem.

Regards.,

[Basara]

Hello, panski.

Did you try to optmize/repair your database? It is versy easy to do in PhpMyadmin tool  - you can find it in your hosting Cpanel.

This is an indication that might have issue with Mysql tables after import.
1. Try to run database table maintenance.
2. check version 1.2.5 and 1.2.6 install/..upgrade.sql or install/..upgrade.php for new table indexes. Apply them in your database. 
This might help.

Also the upcoming AbanteCart version is speed optimized you can try it on TEST site http://forum.abantecart.com/index.php/topic,4652.0.html

[abantecart]

Guys, once again I ask you to provide some kind of assistance to resolve this issue. Side admins are welcome to PM me in order to have any requisites necessarry to handle this problem.

Regards.,

If you tried what was suggested and it did not help, PM me access to your hosting admin. I will check. 

[abantecart]

I have quickly checked your server and did not find major issues.

I suggest a number of optimizations that needs to be done.
1. Reduce number of products you list on the main page.
2. Make sure all images are optimized for banners and products.
Example: This banner is 0.5mb. Too large
https://mantis.ge/mantis/resources/image/1c/e2/e.png
Check other images.
3. Once we release version 1.2.7 (today), create a copy site and upgrade.
New version 1.2.7 has significant improvement for page rendering/loading and has HTML cache.
HTML cache will reduce server load for #1, but #2 will still need to be addressed by you.