MySQL is generally limited by the OS you are running it on. If you
start having thousands of table, the OS is probably going to get
bogged down in trying to keep track of all the file handles needed
for all those tables and indexes. The practical limit to the number
of tables is far lower t
Hi, all
I have 2 questions:
1) Is there any limit on the number of tables I can create in MySQL and
how large I can hold in a database?
2) Does MYSQL support to save binary data file in the table. I can't just
save paths to the files. They files reside in another machine.
Thanks for reply.
X.C
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
> 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
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
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
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.
There is a _lot_ of interlinking among the tabl
