* Brian Reichert
[...]
> I don't know if there's a limit at to how many tables can be handled
> by a single MySQL query.
This limit is actually hardware architecture dependant: You can join 31
tables on a 32-bit server and 63 tables on a 64-bit server.
--
Roger
--
MySQL General Mailing List
Fo
On Mon, May 10, 2004 at 09:49:31PM -0700, Scott Haneda wrote:
> Sorry for the post again, I hijacked a thread and wanted to get this on the
> correct track.
>
> I can not seem to find the section in the manual that talks about the max
> number of tables MySql can use, can someone point me please?
Scott Haneda wrote:
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
interesting storage needs.
There will be a users table, there can be x u
nto a column , is that right ?
userID = autoinc userID in the user table
> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 2:50 PM
> To: MySql
> Subject: Database design.. Asking again
>
>
> Sorry for the post again, I hi
Scott Haneda wrote:
If users become day 1000 and each of those users has 70,000 user_contacts,
that would be 70,000 * 1000 total records in one table, as users grow, this
becomes perhaps too many records in one table. Or at least the potential
for it.
My next option would be to make a new table
Sorry for the post again, I hijacked a thread and wanted to get this on the
correct track.
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
interesting storage needs.
There will be a users table, there can be x users, if all goes
