Advertisement
Guest User

Untitled

a guest
Jan 21st, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. # Query 1
  2. SELECT id
  3. FROM archive, topic
  4. WHERE topic.type=0 AND archive.status=2
  5. AND MATCH(title, description) AGAINST ('+house* +tz*' IN BOOLEAN MODE)
  6. AND archive.topicId = topic.id
  7. ORDER BY archive.featured DESC, archive.submissionDate DESC LIMIT 0,20
  8.  
  9. Total count: 12
  10. Key_read_requests: 2384607
  11. Creating sort index: 7.950430 sec (!)
  12. Duration: 8.851252 sec
  13.  
  14. # Query 2
  15. SELECT id
  16. FROM archive, topic
  17. WHERE topic.type=0 AND archive.status=2
  18. AND MATCH(title, description) AGAINST ('+tz* +house*' IN BOOLEAN MODE)
  19. AND archive.topicId = topic.id
  20. ORDER BY archive.featured DESC, archive.submissionDate DESC LIMIT 0,20
  21.  
  22. Total count: 12
  23. Key_read_requests: 415
  24. Creating sort index: 0.003449
  25. Duration: 0.004054 sec
  26.  
  27. tz*: 135092
  28. tz: 25596
  29. house*: 12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement