auto-increment column in temporary table

[Anon]

I have a chat program that will run very slowly if database access is from the hard drive.

I thought of creating a temporary table TYPE=HEAP which will run directly from ram. This would have been a perfect solution, except for the fact that mysql does not allow "auto-increment" column in temporary tables.

Is this just an issue with mysql, or is it the same with other databases?

I need an auto-increment column, because my script depends on last_insert_id().

Thanks.

Richie.

[Anon]

Have you prototyped it with a hard drive? With plenty of RAM to use as a cache, mysql is pretty fast. Otherwise you will probably have to use something in the web server to generate the IDs (application variable, semaphores, etc). What's available depends on your platform.

[Anon]

I'm on Windows platform.
I've been looking into semaphores, but haven't found a good article on it. I'll take another look at it.

Thanks.

Richie.