Search a little slow
Search a little slow
Hi, I'm using the advanced search on a site. Everything is working ok, but it is slow. Is there something I can do to make it work faster? Do I have to do the indexing of the site or does it make it automatically?
Thanks.
- info
- New User
-
-
-
- 1 Posts
Re: Search a little slow
Advanced Search does not use and index, it does however us cache (you can Enable and disable it under the Advanced Search settings.
It may not required but you may want to check is that your Joomla Cache Plugin is enabled and published last. (You may also want to enable caching in Joomla Globla Config)
Go to Joomla Administrator - Extensions - Plugin Manager - System-Cache - in ordering set Order-Last.
Go to Joomla Administrator - Site - Global Configuration - Server - Cache Settings
Re: Search a little slow
Although cache helps to a certain extent, every time a user runs a completely new search, the database is pounded by a slow query which sends the CPU cycles to the roof.
Our slow queries log on a resourceful VPS, where MySQL is the only relevant process running, is riddled with entries of the type below:
Code:
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext, a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END as catslug, u.id AS sectionid, CONCAT_WS( "/", u.title, b.title ) AS section, "2" AS browsernav, 1 AS AdvancedSearch, CONCAT("images/stories/", b.image) AS icon FROM scqr_content AS a INNER JOIN scqr_categories AS b ON b.id=a.catid AND b.access <= 0 INNER JOIN scqr_sections AS u ON u.id = a.sectionid WHERE ( (a.title LIKE '%orange%' OR a.introtext LIKE '%orange%' OR a.fulltext LIKE '%orange%' OR a.metakey LIKE '%orange%' OR a.metadesc LIKE '%orange%') OR (a.title LIKE '%suisse%' OR a.introtext LIKE '%suisse%' OR a.fulltext LIKE '%suisse%' OR a.metakey LIKE '%suisse%' OR a.metadesc LIKE '%suisse%') ) AND a.sectionid != 54 AND a.state = -1 AND u.published = 1 AND b.published = 1 AND a.access <= 0 AND b.access <= 0 AND u.access <= 0 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-03-04 21:29:57' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-03-04 21:29:57' ) AND ((a.`catid` NOT IN (0, 136, 148, 199, 201, 140, 153, 161, 168, 170, 183, 146, 149, 218, 219, 220, 221, 222, 223, 224, 225, 171, 174, 189, 190, 141, 205, 206, 207, 208, 209, 210, 211, 212, 175, 176, 202, 213, 142, 203))) ORDER BY a.created DESC LIMIT 0, 117;
Must be noted that we are talking about a daily publication comprising about 17.000+ articles.
Regrettably, both Joomla and many 3rd party extensions are not precisely efficient when it comes to SQL syntax, particularly on large databases.
We even create indexes in some columns, to no avail.
Environment:
Joomla 1.5.25
Advanced Search 3.0.2.1321
- ETG
- New User
-
-
-
- 5 Posts
Re: Search a little slow
I will enquire with the developers to see if there is a way to 'optimize' these searches.
I'd expect a lot server resources to be used to try and query the full database for a limited amount of time on large databases.
Re: Search a little slow
I am having the same problem. Your search is VERY slow usually. It takes anywhere from 10-20+ seconds before the search returns results.
I have also noticed that once results are returned, it is often times NOT using the suggested word function, which I have successfully setup to use Bing.
I also notice that some hidden filter seems to be applied to our search if you don't get any results initially. It becomes impossible to search again until you click the Reset filters link.
I have no idea what is wrong that could be causing that.
http://www.labtestnavigator.com/
- clinlabnav
- New User
-
-
-
- 2 Posts
Re: Search a little slow
Suggested will only appear if there are no results,
the speed of the search depends on the size of the tables that are being searched and the resources available on the server.
Forum Legend
Topic
New
Locked
Sticky
Active
New/Active
New/Locked
New Sticky
Locked/Active
Active/Sticky
Sticky/Locked
Sticky/Active/Locked



Assistance with technical questions, product inquiries and customer service can be found in our 