To reply to this, I think we have to understand why you have chosen to
split the tables at all. It seems to me that this, by introducing a
two-level lookup, is certain to be slower than any possible single table
lookup. Generally, Log A + log B is bound to be larger than log (A*B).
It appears
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, January 13, 2006 9:41 AM
To: John McCaskey
Cc: MySQL
Subject: Re: Huge number of tables with InnoDB
To reply to this, I think we have to understand why you have chosen to
split the tables at all. It seems to me
Alec writes
...Generally, Log A + log B is bound to be larger than log
(A*B)...
Errm, log A + log B exactly = log(A*B)
:-) .
PB
-
[EMAIL PROTECTED] wrote:
To reply to this, I think we have to understand why you have chosen to
split the tables at all. It seems to me that this, by