J-BusinessDirectory - J-BusinessDirectory and many business entries

Dear support,

I would like to know if this component is able to manage a large number of entries.

I mean: your demo has twelve business and we tested it with two hundreds and it was okay... but now that we have thousands of entries, the website is no longer usable: 13-18 seconds to load the fastest page!

Is there something that I did not considered?

Is there a live example with thousands of business that we can see to understand what we can improve ?

Thanks in advance

Hi Roberto,

Did you make a test with 4.8.0 Beta to see if there is any improvement? 

"CACHE SYSTEM

An integration with Joomla cache system has been implemented to provide better performance. 
As you know a high number of items in the directory extension can lead sometimes to a longer response time in displaying the results. With the new cache system when the search is done the second time, the result will be displayed much faster."

Dear Slim,

thank you for your quick reply.

I will try to duplicate the website and update everything to the latest versions and I will let you know if there are improvements.

Thanks

Thank you Roberto.

I'm very interested about the test results. I have around 300 business and is good to know :) ... my loading time on business listing page is 6-8 seconds (vps 4 cpu x 2.1 Gh - 6 GB Ram + 2 Gb swap )

In my opinion the directory must handle with now probleme tens of thousands of listings with a loading time lower then 3 seconds ... the listings can have offers and events (let's say 10 for each business) and results hundreds of thousands of listings for offers and events ... with so much content you can have a lot of searches made on the website by the users in the same time ... must handle all easily

Hi Scot,

I'm curious about your site ... can i please see it ?

Hi,


The search query for JBD has been optimized to provide the best performance.
The search response time depends on multiple factors.

1. The number of fields that are used for the search.
2. The number of tables that are joined to perform a search
3. The number of records that are retrieved.
4. Other Joomla plugins that are installed on your website.
5. PHP and Mysql configuration
6. Server load.

There are 2 search queries executed, one for retrieving the results and one for the total number of results for pagination purposes.
On a server with 10.000 listings, each query is executed in 2 seconds resulting in a search time of 4 seconds.
But when you execute a query not only the JBD is executed. There are other plugins and extensions that need to be initialized and run leading in a higher response time.