-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 09/11/07 12:02, Phoenix Kiula wrote:
> On 12/09/2007, Ron Johnson <ron.l.johnson@cox.net> 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-----