Re: What to do if a table is supposed to get > 3GB data per day?

2006-12-27 Thread Saqib Ali
wow 30GB is a lot of data. Do let us know what kind of hardware / OS you are using. In the past I have worked with larger tables then these, but I was using Objectivity DB running on UltraSPARC 64bit architecture. -- Saqib Ali, CISSP, ISSAP http://www.full-disk-encryption.net -- MySQL General M

Re: What to do if a table is supposed to get > 3GB data per day?

2006-12-27 Thread ViSolve DB Team
past data, then well and good compress the table.[only for myisam] shell> myisampack .MYI shell>myisamchk -rq .MYI Thanks ViSolve DB Team - Original Message - From: "Asif Lodhi" <[EMAIL PROTECTED]> To: Sent: Thursday, December 21, 2006 5:24 PM Subject: Wh

Re: What to do if a table is supposed to get > 3GB data per day?

2006-12-21 Thread Dan Nelson
In the last episode (Dec 21), Asif Lodhi said: > Would you like to express your opinion as to what design strategy to > take if a table (used for read operations only) is supposed to get > more than 3GB of data per day? With 1000 simultaneous users ? With that data rate, you'll definitely have to

What to do if a table is supposed to get > 3GB data per day?

2006-12-21 Thread Asif Lodhi
Hi, Would you like to express your opinion as to what design strategy to take if a table (used for read operations only) is supposed to get more than 3GB of data per day? With 1000 simultaneous users ? -- Thanks in advance, Asif