-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/11/07 12:02, Phoenix Kiula wrote: > On 12/09/2007, Ron Johnson <[EMAIL PROTECTED]> wrote: >> How (on average) large are the records you need to insert, and how >> evenly spread across the 24 hour day do the inserts occur? > > > There will be around 15,000 inserts in a day. Each insert will have > several TEXT columns, so it is difficult to predict, but about 30,000 > to 100,000 characters in each row. And yes, the inserts will be very > consistently timed every day.
15000*100000 = 1.5GB. 1.5GB / (24*60) = ~1 binary MB. Any computer that that can't write 1 megabyte per minute in a day should have been retired in 1970. So..... Unless there's something that you aren't telling us, this should be handleable by a Wal-Mart Special with an extra-large disk in it. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFG5vxLS9HxQb37XmcRAoneAKCsw0W92jmySlGaRFpkZsvIJovTJwCgqPFg j4Fp2uV5vf+OIVhnuJSaQxs= =4u83 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
