Re: How Huge of your mySQL database or table in your former Instance

2002-01-08 Thread Jeremy Zawodny
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote: On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : : So, could you give me some advice that if it is feasible ? Or show : me your successful cases of

Re: How Huge of your mySQL database or table in your former Instance

2001-12-16 Thread Jeremy Zawodny
On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? How about a table with 260 million rows? We've got one that is

Re: How Huge of your mySQL database or table in your former Instance

2001-12-16 Thread Philip Molter
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : : So, could you give me some advice that if it is feasible ? Or show : me your successful cases of using mySQL which is supporting very : large DB or tables with

How Huge of your mySQL database or table in your former Instance

2001-12-09 Thread Ares Liu
All, Now I want to design a database which contains more than 10G data to use. I think the largest table in my db will contains more than 30 million records and the amount of this kind of table will be up to 7 or 10. In my instance there won't be so many clients connecting. normally, there are

Re: How Huge of your mySQL database or table in your former Instance

2001-12-09 Thread Ares Liu
Thanks very much Paul, Could you like to tell me what time spent in your querying ten thousands of records from tables one time? In my test, when I query 10,000 records from a table which contains 17 millions records total, it will cost less than 1 second of querying INDEX, or cost more than 30