It is impossible to add an index without hurting the insert
queries; the question if it hurts it significantly enough for you to
notice. I would just try creating one and see what happens, you can
always delete it later if it makes the inserts/updates too slow.
On Sun, 22 Oct 2006, Asif Iqbal wrote:
Resending my question in case anyone missed to catch it the first time
around.
On 10/9/06, Asif Iqbal <[EMAIL PROTECTED]> wrote:
I am noticing from my slow log file (5 secs) that the following query
on mysql 4.0.24 is taking a 11 secs
# Query_time: 11 Lock_time: 0 Rows_sent: 299925 Rows_examined: 983836
SELECT * FROM Transactions where Transactions.type = 'create';
mysql> explain SELECT * FROM Transactions where Transactions.type =
'create';
+--------------+------+---------------+------+---------+------+--------+-------------+
| table | type | possible_keys | key | key_len | ref | rows
| Extra |
+--------------+------+---------------+------+---------+------+--------+-------------+
| Transactions | ALL | NULL | NULL | NULL | NULL | 984572
| Using where |
+--------------+------+---------------+------+---------+------+--------+-------------+
It has to go thru about 1 million rows and not using any index.
Is there any index, that I can create, to improve this w/o hurting any
other query?
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
