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