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

Compared zeta & epsilon themes and number of database queries is pretty much similar (+-20%).

Hi,

I still can't use the Zeta theme, whenever I enable it the database load triples and the category pages are about twice as slow to respond and this causes Google to not index many of the pages due to a slow response rate.

I have attached a screen grab of my cPanel server load, highlighting when I enabled the Zeta theme.  The amount of visitors also went down at the same time Zeta was enabled.

The site has approximately 100k listings and is hosted on a pretty powerful server with lots of memory. I never have any problems with server load on either the Delta or Epsilon themes.

I'm using the latest Zeta theme and Osclass and only the latest Osclasspoint plugins.

I'd be grateful for any recommendations as I would like to use the Zeta theme on my site.

Cache, memcache, cloudlfare, db optimization...
Demo runs on shared hosting and is fully vital.
DB queries are similar to Epsilon/Delta theme.
It make sense to review those queries in DB debug mode if optimization/indexes are not required.

Alternative is to cut particular sections from theme those require extra database load like category list on search page.

Hi,

Thanks for your suggestions.

I have removed sections from the search page, this helps a little bit but there is still a very high server load compared to your other themes.

I use your cache plugin and have tried APCu and Memcached which helps for non logged in customers, Cloudflare delivers my static content but the site still uses a lot more server resources, mainly high cpu usage database queries than previous themes. Maybe it is only a problem for busier sites with 100k+ listings?

I have switched back to the Delta theme that responds great when you have many visitors.

Hopefully the Zeta theme is updated in the future and I'll try it again.

Many thanks,
Spencer

When you compare themes, number of queries they generate (including Osclass queries) is pretty much same, usually 80-150 queries.

Hi, thanks for the reply.

It is not just the amount of queries, it is that the queries cause a high load because of the resources they use compared with other themes.

I'll enable database logging on my sever and find the queries causing the problem.

Many thanks

Which queries?
If it is nit about amount, some queries must take more time.
You have some queries those takes more than 0.1 sec? Usually time should be under 0.001s per query