10 replies to this topic

[david052010]

Hello everyone. I just installed JBZOO components use to open the page speed is very quick, but I gradually add more data and products to my website and found the website open more and more slowly, as long as I close the JZOO extension (module,plug) open the site speed back to normal. At present our website data (zoo_item) 213208, (zoo_search_index) 213208. The entire page to access search module of JBZOO after open slowly, banned after the normal speed, but in the inventory page is still very slow. My demo site address: www.tephon.com What idea is there to help me improve the situation? Future data and products will be more and more, will be more than 500000+

[SmetDenis]

Hello, David.

Sorry, but I cann't open your website tephon.com

[david052010]

The server was just restart can open to try again

[Kess]

Hello,

 

500 000 items is a lot. You need a good server and some optimizations in order to achieve acceptable seed.

 

Let's try to make some optimization tweaks, maybe it will help you. Better make a backup before trying, just in case.

 

• Disable all unnecessary Joomla plugins. Especially search and smart search.
• It will be faster to use "exact" search mode of JBZoo filter instead of "Full text".
• Don't use multiple sortings.
• Don't use ZOO sorting, especially the alphabetical one.
• Enable caching.
• It's better not to use file cache. php memcache module works very well.
• If you have a static content, you can enable caching plugin. Only drawback is that it doesn't check if the information have been updated.

Also, please, tell us the technical info about your server. Maybe it's just too weak for such large website.

[david052010]

Hello,

 

500 000 items is a lot. You need a good server and some optimizations in order to achieve acceptable seed.

 

Let's try to make some optimization tweaks, maybe it will help you. Better make a backup before trying, just in case.

 

• Disable all unnecessary Joomla plugins. Especially search and smart search.
• It will be faster to use "exact" search mode of JBZoo filter instead of "Full text".
• Don't use multiple sortings.
• Don't use ZOO sorting, especially the alphabetical one.
• Enable caching.
• It's better not to use file cache. php memcache module works very well.
• If you have a static content, you can enable caching plugin. Only drawback is that it doesn't check if the information have been updated.

Also, please, tell us the technical info about your server. Maybe it's just too weak for such large website.

I use the cloud server, its configuration is

Memory 2048MB

Disk (Raid 10) 120GB

CPU 4

This server using APACHE running on this server, PHP5.4.16, and two site open speed is very fast.

So far my network using the JBZOO extension has been uploaded 400000 + data. The existing1GB database file.

According to your suggestions I have made some adjustments in the background, but the effect is not good.

Before I set up the index of data table

[SmetDenis]

Hello,

Can you show me your website ?
I would like to see system profiler information and how to work some system functions, your database and SQL queries.
So I need access for FTP and Joomla Control Panel.

Sorry, but I think 400 000 items are really too many for JBZoo.
It can works only after a special code optimization.

Best regards, Denis.

[david052010]

I had sent the private message for you. pls check it.

[david052010]

Find someone DDOS attack on my server, I tried to forbid their IP segment: 37.58.0.0/16

[SmetDenis]

Hello,

 

I added some code optimizations, enable cache and disable random in the Zoo item module.

Please, check your website.

[david052010]

Sir, very very very very very very very thank you for your support. My website open speed has been very good promotion. Now I will continue to upload new data, will reach 800000 + items. Hope later versions of JBZOO on large data to optimize and improve. Thank you again for your help.