Hi,

I really like the new Zeta theme :-)

I've noticed when I switched from Epsilon to Zeta theme, the server load trebled with the same amount of traffic, the main extra load was on the database usage. I use the caching plugin which helps a bit for the non-logged in users.

The extra page load is mainly on the category pages, the item listing pages are still loading fast.

I'm starting to get 520 error messages from my server due to the extra load, I didn't get the server busy 520 errors from using the Epsilon theme.

Is there anyway modify the coding to reduce the server load?

Many thanks

What are those queries? You should see change in query list (db debug log)

Hi,

It looks like the amount of database calls with the new theme that is slowing the site down dramatically.

If I Look at the /search page using the Epsilon theme the (Total queries: 193 - Total queries time: 0.093809127807617 sec) , if I use the Zeta theme for the same page, Database queries (Total queries: 1764 - Total queries time: 0.60689187049866 sec)

Looking at my Google webmaster tools, I can see that Google is reporting the page load time has increased significantly too which is resulting in less traffic to my site.

I hope that you have a solution to the high load times for the Zeta theme as I really like the professional look and feel of the theme.

Many thanks,
Spencer

But what are those queries? Are there repeating queries or new queries?
You use Osclass 8.2?

Will doubkecheck how it looks like on demo.

Hi,

Thanks for your help.

I had to switch back to the Epsilon theme as the huge server load increase using the Zeta theme resulted in slow page loads and I lost a lot of rankings in Google search results.

I have attached a graph from Google Webmaster tools of the Google crawler response times and highlighted when I switched-over to the Zeta theme.

I've sent my database server query list to you by direct message as it contains information on my server settings.

Using APCu does help a bit to reduce server loads but it does not come close to the response times of the Epsilon theme.

I'm using the latest release of Osclass and the latest Zeta theme too.

I hope that there is a solution to the high load times as I really like the new modern, professional look of the Zeta theme.

Many thanks

Reviewed your logs.
There is this query repeating quite often:
SELECT a.*, b.*, c.i_num_items
FROM (osfc_t_category as a)
INNER JOIN osfc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = "en_US")
LEFT JOIN osfc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = {ID}
ORDER BY i_position ASC
Looks like Osclass function to get subcategories was not that effective.
Please update theme and try again.

Hi,

Thanks for the update.

The new version is faster now with a lot less database calls than the previous release. But it is still twice as slow as the Epsilon theme and the Delta theme for category results.

If I enable APCu then the Epsilon theme is a lot faster than the Zeta theme for category and search results.

I have attached the results for the new version of the Zeta theme.

Many thanks