1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Very log query Time with digitalpoint sphinx

Discussion in 'MySQL' started by michael24179, Mar 10, 2016.

0
  1. #1
    Good morning.

    I have problem with my vbulletin sql. I have install digitalpoint sphinx and i have very log query time. I don't know how i make fix this problem. 

    # Time: 160311  8:00:15
# User@Host: debian-sys-maint[debian-sys-maint] @  [192.168.10.1]  Id: 441924
# Query_time: 9.101344  Lock_time: 0.000113 Rows_sent: 6959018  Rows_examined: 7808108
SET timestamp=1457679615;
SELECT post.postid AS doc_id, tagcontent.tagid FROM digitalpoint_sphinx_delta AS digitalpoint_sphinx_delta RIGHT JOIN tagcontent AS tagcontent ON(tagcontent.contentid = digitalpoint_sphinx_delta.primaryid) LEFT JOIN post AS post ON(tagcontent.contentid = post.threadid) WHERE digitalpoint_sphinx_delta.contenttypeid = (SELECT contenttypeid FROM contenttype AS contenttype WHERE class = 'Thread') AND primaryid BETWEEN 300057 AND 400056;
    Code (markup):
     
    michael24179, Mar 10, 2016 IP