Change session table to HEAP?
Can I change my session table to the HEAP type?
Can someone give me pretty detailed directions how? I've read the manual and it says HEAP does not support auto_increment.. so how can I modify my session table to work?
thanks~
Maybe I should just pour through the vb2 upgrade routine and see how it changes the session table? or it probably just recreates it eh..
Although you could end up with a race condition if you don't lock the tables..
I am betting on Secretariat!
It wouldn't be too easy to convert a 1.1.x session table to HEAP. Although, theoretically, you could kill the auto_increment, and before inserting just do SELECT MAX(sessionid) AS max FROM session; Although you could end up with a race condition if you don't lock the tables..
#If you have any other info about this subject , Please add it free.# |