|
Ok, so after I received an email from my host saying that my database is using too many resources and slowing down other peoples sites … I went and investigated the problem.
I spoke to a programmer and he gave me a small script to see just how many queries are there and we found out that I had over 700 queries.
After I removed the category module that went down to almost 500 queries.
After further investigation my friend found out that those queries happen because of SEO URLS and told me that shoppica has coded it’s own lookups for seo urls .
So now I need the rewrite code removed and replaced with opencart rewrite code.
Without shoppica the queries went down to about 29.
Before all this I optimized my SQL database using indexes but that didnt help much.
I will send the website url and more details (possibly even what my host said) for you to check out if you give me an email address or skype ID.
Thank you!
|
|
|
Hi,
The database queries depend on the categories you have in the menu. Opencart has lower count queries because it displays only two levels deep. Shoppica displays the entire category tree. Every category makes one additional query to determine the SEO url. This query is ‘cheap’ however, as it is very simple.
Shoppica 2 we have reduced the additional queries greatly, so you can try. The major opencart performance problem is the products count in category menu and it has nothing to do with Shoppica. In general, Shoppica 2 provides very much the same performance as the default opencart theme, so you can safely use it.
However, we have prepared a special Shoppica plugin – SmartCache, which we will release for free in the next week. With this plugin we achieved 200% better performance than OpenCart.
You can download Shoppica 2 from your ThemeForest account.
Best,
ThemeBurn team
|
|
protechtrader on
ubadaalamer on
edugarsb on
gazza1970 on
kks787 on
mtaitimu on
suhrig on
izmailskiy on
magicbit on
logdoc on