Page 1 of 8 123 ... LastLast
Results 1 to 10 of 77

Thread: Jobroller is slow, My Host Provider asked me to contat you!

  1. #1
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts

    Jobroller is slow, My Host Provider asked me to contat you!

    Hi

    My website is being thorettled by my host provider (CPU limitation). My Host advised me to read the log files in MySQL_slow_queries directory and i find this message in the most recent log file:

    Code:
    # Mon Aug 12 11:05:36 2013
    # Query_time: 1.582011  Lock_time: 0.000298 Rows_sent: 2  Rows_examined: 7793
    use yesijobc_wor1;
    SET timestamp=1376327136;
    SELECT SQL_CALC_FOUND_ROWS  wrd_posts.ID FROM wrd_posts  LEFT JOIN wrd_postmeta ON wrd_posts.ID = wrd_postmeta.post_id  WHERE 1=1  AND (((wrd_posts.post_title LIKE '%factory%') OR (wrd_posts.post_content LIKE '%factory%') OR ((wrd_postmeta.meta_key = '_Company') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_address') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = '_CompanyURL') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_short_address') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_country') AND (wrd_postmeta.meta_value  LIKE '%factory%')) OR ((wrd_postmeta.meta_key = 'geo_short_address_country') AND (wrd_postmeta.meta_value  LIKE '%factory%')))) AND (wrd_posts.post_status = 'publish') AND (wrd_posts.post_type = 'job_listing') GROUP BY  wrd_posts.ID  ORDER BY wrd_posts.post_date DESC LIMIT 0, 10

    Any idea why this query is taking too long so as i get CPU limitation?

    Thank you

  2. #2
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    40,693
    Thanks
    166
    Thanked 3,387 Times in 3,258 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

  4. #4
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #5
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #6
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  7. #7
    jomarkosabel's Avatar
    Join Date
    Mar 2009
    Location
    Philippines
    Posts
    40,693
    Thanks
    166
    Thanked 3,387 Times in 3,258 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. However, you can send a PM to follow up and remind me if I missed your support request/thread.

    Thank you and have a nice day.

  8. #8
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  9. #9
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  10. #10
    Thread Starter
    Veteran mjbari's Avatar
    Join Date
    Jan 2013
    Posts
    598
    Thanks
    8
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Page 1 of 8 123 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Jobroller Dead Slow
    By petkodonev in forum Report JobRoller Bugs
    Replies: 14
    Last Post: May 29th, 2013, 06:20 AM
  2. Slow loading Jobroller site
    By gregpill in forum Report JobRoller Bugs
    Replies: 1
    Last Post: September 17th, 2012, 04:31 AM
  3. Replies: 3
    Last Post: September 15th, 2012, 11:37 PM
  4. [SOLVED] The contat form of single-page ads not work
    By Orzdy in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: October 31st, 2011, 12:11 PM
  5. Jobroller: very slow and poor performance
    By westville in forum Report JobRoller Bugs
    Replies: 3
    Last Post: October 30th, 2011, 03:23 AM