Change session table to HEAP?

[Overgrow]

I still run a modified 1.1.3 (yea yea no security hole)...

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~

[Overgrow]

Someone must have some advice?

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..

[Mike Sullivan]

The session tables' schemas are completely different. The concepts behind them are different.

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..

[Overgrow]

Thanks Ed!

[MattR]

Originally posted by Ed Sullivan
Although you could end up with a race condition if you don't lock the tables..

I am betting on Secretariat!