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?