I need to insert data into a table in real time. The table is simple... int, char, char, double, int.
First I assume that insertion will be much faster if the table is not indexed although indexing would be nice.
Each day the table is cleared out but towards the end of the day the table could...