Re: Search in a tagging system
instead of deleting, have one more column named deleted_row ENUM(0,1) default 0
and then do an update xx set deleted_row=1
and on your final select add
where deleted_row=0
then make sure that those temp tables are created on memory and not on disk (disk tables are very slow)
Diego Medina
Web Developer
http://www.fmpwizard.com
P.S. Please read
this post if you are going to post code
Subject
Written By
Posted
February 15, 2007 04:14PM
November 14, 2007 02:09AM
Re: Search in a tagging system
November 14, 2007 05:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.