How much is enough?

[Anon]

Hello gurus

I just want to know what is best way to use MySQL. For example,

how many table can I put in one database and keep the same performance?

Is it better to have all tables in one database or several ones?

What is the max no of tables can I have in one data base.

Can I put a whole text in the database. I mean I have about 1000 records. Each record has five fields and one of the fields is a text files that is about 1/2 a page. Can I put them in one table?

[Anon]

The number of tables in a database does not have a significant affect on performance.

Tables should be grouped in databases logically. Related tables should be in the same db.

I'm not sure of any limit on the number of tables in a db. Check at mysql.com.

If you have a field that needs to contain text greater than 255 characters you can use one of the various text/blob types. If you want to use case insensitive searching on the field use a text type not a blob.

TEXT or BLOB can contain 65535 characters
MEDIUMTEXT or MEDIUMBLOB: 16777215 chars
LONGTEXT OR LONGBLOB: 4294967295 chars