On Thu, 2005-06-02 at 17:53 +0200, Pedro Pascual wrote:
> * Heavy inserts in active file (5000000 per day), closed every day
> (no more inserts)
If you will be querying from the active file, then
it will work best to batch your inserts. Perhaps
insert into a temporary table. Then when the temporary
table accumulates a few thousand entries, do this:
INSERT INTO maintable SELECT * FROM temptable;
DELETE FROM temptable;
If you try to do 5 million separate INSERT statements
(without a BEGIN...END wrapper around groups of INSERTs)
then each INSERT will be a separate transaction. 5
million inserts per days is 58 transactions per second - which
is aggressive. It will work better to batch your inserts
in order to keep the number of transactions below 1 or
2 per second.
--
D. Richard Hipp <[EMAIL PROTECTED]>
