hey guys.. im kinda confused now... I have a mysql table which has over 90,000 recods... I have the following mysql query :

SELECT descr, link, ddate from links WHERE (descr like %bored%) ORDER BY ddate DESC LIMIT $offset, 100;

now, the above query causes mysql load to sky rocket to 90%... but if i try the following :

SELECT descr, link, ddate from links WHERE (descr like %bored%) LIMIT $offset, 100;

it remains static between 15-20....

the table is indexed on ddate.. both link, and descr are varchar(255) character columns.. and ddate is int(20) column storing a unix time stamp...

any ideas on how i can get the order by to function without overloading mysql?

thanks
kunal