• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MySQL Question - HEAP Tables / Table Type for SPEED?

S

Superwormy

Golden Member

Say I have 3 or 4 really really often used ( for SELECTs only ) tables in MySQL, woudl it be a good idea to, whenever the MySQL server starts up, take all the data from those tables ( MyISAM ) and make 3 or 4 new HEAP tables to do the SELECTs from?

That way I don't need to worry about losing the data in case of a crash... and will I see a big benefit because HEAP tables are so much faster than MyISAM?


Thnaks!
 
You must log in or register to reply here.
Back
Top