Is like that much faster than =? If so, this would be a good thing to know. I'm
assuming that not putting a % either before or after the variable would make it the
equivilent of an =.
Can you possibly point me somewhere that explains this a bit or possibly gives some
kind of benchmarks?
Tha
use one database, and lookup the clients table names, and
>use a merge table for reports.
>James Blackwell wrote:
>
> I have a similiar situation where I've got a huge database that maintains data for
>quite a few clients. Queries have gotten extremely sluggish.
>
>
I have a similiar situation where I've got a huge database that maintains data for
quite a few clients. Queries have gotten extremely sluggish.
What I'm working on right now is to have a control database with a single table that
contains a unique identifier for each client and a database name.
Can anyone shed a little light on this for me? I've got a mysql installation that has
been running for over 2 years now. As the database has grown to over 250Meg (not TOO
large at all) things have kind of slowed down. We're running this on a RH box with
mysql v3.23.32.
So, we bought a new s
