in
> without options.
You may also see a speed increase by adding the indexes after the data
is inserted.
--
Andrew Hutchings - LinuxJedi - http://www.linuxjedi.co.uk/
Windows is the path to the darkside...Windows leads to Blue Screen. Blue Screen
leads to downtime. Downtime leads to su
from table_name where ... order by last_update
desc limit 10) as tbl order by tbl.last_update;
Rich in Toronto
I guess you could do:
select * from table WHERE id > ((SELECT MAX(id) from table) - 10);
Its not perfect, but it executes pretty fast for me.
--
Andrew Hutchings - LinuxJed
You need to do -r on node 2 as well, you have only restored half the data.
--
Andrew Hutchings - LinuxJedi - http://www.linuxjedi.co.uk/
Windows is the path to the darkside...Windows leads to Blue Screen. Blue
Screen leads to downtime. Downtime leads to suffering...I sense much
Windows in you...
?
>
> Thank you very much for your help~
>
> 22-06-2007
To answer point 2:
Firstly, as previously stated by someone else you need to ditch the
UCASE, performing functions on indexes pretty much voids the index.
Secondly if you have a % before a word then you are going t