Re: Limits of mySQL

2002-04-30 Thread Jeremy Zawodny
On Wed, May 01, 2002 at 08:02:20AM +0200, Svensson, B.A.T. (HKG) wrote: > > Do you have any idea how well MySQL scales with tables containing > some 10th of million rows of data? How about 280 million? We've got one that big. It performs very well--because we have it properly indexed and don't

RE: Limits of mySQL

2002-04-30 Thread Svensson, B.A.T. (HKG)
> I'm not a suitable person to compare MySQL against other databases but MySQL > will cope with this size of database if the tables are properly indexed and > your queries optomised. Here our main database has over 90 tables and several > of our tablse hold about the amount of data your'll acrue

Re: Limits of mySQL

2002-04-27 Thread Jeremy Zawodny
On Sat, Apr 27, 2002 at 05:15:10PM +1200, Sam Minnee wrote: > > I've been asked to put together a very large (well, it's large to > me) database, and while mySQL is great for my current uses, I > haven't had experience with stuff of this scale. > > The database will have about 88 tables, with up

Re: Limits of mySQL

2002-04-27 Thread nigel wood
On Sat, 27 Apr 2002, Sam Minnee wrote: > I've been asked to put together a very large (well, it's large to me) > database, and while mySQL is great for my current uses, I haven't had > experience with stuff of this scale. > > The database will have about 88 tables, with up to 100 fields per table