some info on MySQL?

[Cheap Bastard]

is there a limit as to how many tables are present?
also, what's a common sizelimit or is that set per host?

[Cheap Bastard]

anyone?

[atlas]

What exactly do you mean? You can have as many tables as you want. It really won't make a difference unless you try joining them all together -- at that point your limited to your CPU power and memory.

-mk

[Cheap Bastard]

what i meant was say i'm hosted with like tera-byte, on some plan, not on my own dedicated server.

Is there like something where i can only have X number of tables? (should i take that into consideration while programming a PHP script)
and is there a common sizelimit for a MySQL database? like 40 megs or something...

[atlas]

MySQL can handle millions of records. I've personally pushed it above a couple million entries in one table.

The size in MB isn't the issue, since adding an index (additional key) will speed queries on that field yet increase the size of the db.

-mk

[Woofcat]

You can have as many tables as you want (though you don't want thousands of tables in one database...). And Tera-Byte doesn't have a MySQL size limit that I know of...

[Cheap Bastard]

that's a relief... :)