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
ranks
useravatar
Offline
1 Posts
Administrator has disabled public posting

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

* Please note that all support is handled on this forum.
** Please read the FAQs and Documentation before posting:
Docs: Advanced Search | Agora | JCal Pro | Josetta | RSVP | sh404SEF
FAQs: Advanced Search | Agora | JCal Pro | Josetta | RSVP | sh404SEF

Ron van Schaik
Support Specialist
ranks
useravatar
Online
1087 Posts
User info in posts
Administrator has disabled public posting

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
ranks
useravatar
Offline
5 Posts
Administrator has disabled public posting

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.

* Please note that all support is handled on this forum.
** Please read the FAQs and Documentation before posting:
Docs: Advanced Search | Agora | JCal Pro | Josetta | RSVP | sh404SEF
FAQs: Advanced Search | Agora | JCal Pro | Josetta | RSVP | sh404SEF

Ron van Schaik
Support Specialist
ranks
useravatar
Online
1087 Posts
User info in posts
Administrator has disabled public posting

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
ranks
useravatar
Offline
2 Posts
Administrator has disabled public posting

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.

* Please note that all support is handled on this forum.
** Please read the FAQs and Documentation before posting:
Docs: Advanced Search | Agora | JCal Pro | Josetta | RSVP | sh404SEF
FAQs: Advanced Search | Agora | JCal Pro | Josetta | RSVP | sh404SEF

Ron van Schaik
Support Specialist
ranks
useravatar
Online
1087 Posts
User info in posts
Administrator has disabled public posting

Forum Legend

 

 Topic
 New
 Locked
 Sticky
 Active
 New/Active
 New/Locked
 New Sticky
 Locked/Active
 Active/Sticky
 Sticky/Locked
 Sticky/Active/Locked
 
 

Get the latest updates on our extensions