Originally posted by etones
anyone tested the row level locking then?? :D
must post.. need 5 stars :) hehe
I had a play with the Innodb tables. I converted the vB tables. I came across two major problems. One was the 8k limit for a field. This meant that the post table couldn't be converted (one of the main tables that would have benefited :rolleyes: ) and two was with the search function. The word and searchindex tables were converted but when a search was done on a common phrase, the query failed. I think it had something to do with the number of items in the 'where' or 'in' clause. So I gave up and I'm sticking with MyISAM :)
By the way... I've changed the star ranks. it's now easier to get promoted. There are 10 levels and the post requirements are: 5,10,25,50,100,200,300,500,750.... and something special for 1000 posts :D