I’m setting up tables to store details of visitors. One table with details of the visitor session, and another containing the pages they viewed. We’re looking at upwards of 4 million records for the visitors table and 20 million for the pages table.
I’d probably be running occasional queries on the tables and obviously I wouldn’t want that to slow down the user tracking. I could, if necessary, insert into a temporary table and copy across to the main table at non-peak times?
The default table type is MyISAM. Is this the best table to use or would another be more suitable?