Hi Timwi,
Use explain:
+-------+-------+--------------------------+-----------+---------+------+------+-----------------------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+-------+-------+--------------------------+-----------+---------+------+------+-----------------------------+
| old | range | old_title,user_timestamp | old_title | 255 | NULL | 1 | where used; Using temporary |
+-------+-------+--------------------------+-----------+---------+------+------+-----------------------------+
Thanks for your quick reply. How did you get an index for "old_title"? My downloaded version doesn't have this. When I tried to create one a couple weeks ago, after around 24 hours it filled up the remaining 12 GB of my hard drive and crashed, so I wasn't able to create it. Here are the indexes currently available for the table "old":
Key_name Column_name old_id old_id old_timestamp old_timestamp old_namespace old_namespace old_namespace old_title name_title_timestamp old_namespace name_title_timestamp old_title name_title_timestamp inverse_timestamp user_timestamp old_user user_timestamp inverse_timestamp usertext_timestamp old_user_text usertext_timestamp inverse_timestamp
I think if I had "old_title" indexed, things would be a lot easier. Any tips?
Thanks.
Claudio
______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca