This project has begun!
View Single Post
12-30-2008, 12:51 AM
Join Date: Oct 2007
Location: Manchester, UK
Nothing is wrong with rolling back, do we need it though (talking from the project POV)?
I was always told that if the table was going to receive more SELECT queries than INSERTS, UPDATES, DELETES .... then MyISAM was the engine to choose, I could be wrong I'm no DB Admin.
Also I don't think innoDB supports full-text indexing.
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)
View Public Profile
Send a private message to sketchMedia
Visit sketchMedia's homepage!
Find More Posts by sketchMedia