# Please help me optimize mysql query **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [December 12, 2009, 10:34pm UTC](https://forums.percona.com/t/please-help-me-optimize-mysql-query/1305 "2009-12-12T22:34:44Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![thanhh83](https://avatars.discourse-cdn.com/v4/letter/t/e9c0ed/32.png) [@thanhh83](https://forums.percona.com/u/thanhh83)\ **Post date:** [December 12, 2009, 10:34pm UTC](https://forums.percona.com/t/please-help-me-optimize-mysql-query/1305/1 "2009-12-12T22:34:44Z")
Hello Please help me optimize mysql query below I have two table table 1: “tag” tagid int(10) unsigned NO PRI NULL auto\_increment tagtext varchar(150) NO UNI NULL dateline int(10) unsigned NO 0 INDEX status Table Non\_unique Key\_name Seq\_in\_index Column\_name Collation Cardinality Sub\_part Packed Null Index\_type Comment lc\_tag 0 PRIMARY 1 tagid A 242988 NULL NULL BTREE lc\_tag 0 tagtext 1 tagtext A 242988 NULL NULL BTREE table 2: tagsearch tagid int(11) NO MUL 0 dateline int(11) NO MUL 0 Index status Table Non\_unique Key\_name Seq\_in\_index Column\_name Collation Cardinality Sub\_part Packed Null Index\_type Comment lc\_tagsearch 1 tagid 1 tagid A 222067 NULL NULL BTREE lc\_tagsearch 1 dateline 1 dateline A 2664809 NULL NULL BTREE I use query below and get data with 3 seconds SELECT tagsearch.tagid, tag.tagtext, COUNT(\*) AS searchcount FROM tagsearch AS tagsearch INNER JOIN tag AS tag ON (tagsearch.tagid = tag.tagid) WHERE tagsearch.dateline \> 1258084959 GROUP BY tagsearch.tagid, tag.tagtext ORDER BY searchcount DESC LIMIT 10 Explain 1 SIMPLE tagsearch range tagid,dateline dateline 4 NULL 696429 Using where; Using temporary; Using filesort 1 SIMPLE tag eq\_ref PRIMARY PRIMARY 4 tagsearch.tagid 1 Using where I don’t know how to optimize this query please help me Thanks in advanced Thanh ---
**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\ **Post date:** [December 14, 2009, 3:59pm UTC](https://forums.percona.com/t/please-help-me-optimize-mysql-query/1305/2 "2009-12-14T15:59:11Z")
That type of query is hard to improve. It’s usually better in something like Sphinx.