--On Sunday, June 13, 2004 12:56 -0700 David Blomstrom
<[EMAIL PROTECTED]> wrote:
Aha! I added "EXPLAIN," like this...
Please read the docs. And use the mysql CLI/monitor tool.
Explain does just that, it EXPLAINs to you, the database programmer, what
the MySQL engine will do when it goes about
INDEXes grasshopper, INDEXes.
--On Sunday, June 13, 2004 11:26 -0700 David Blomstrom
<[EMAIL PROTECTED]> wrote:
I have a MySQL table with about 3,500 rows and 30
columns. There are rows for each of the world's
nations, each of the 50 states, some 3,000 U.S.
counties, Canada's provinces, etc. Obv
--- Emmett Bishop <[EMAIL PROTECTED]> wrote:
> David,
>
> It sounds like you need some indexes on your table.
> Do
> this... put the word EXPLAIN in front of the select
> statement to you use to get your data. For more
> info,
> check out this link
> http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
I have a MySQL table with about 3,500 rows and 30
columns. There are rows for each of the world's
nations, each of the 50 states, some 3,000 U.S.
counties, Canada's provinces, etc. Obviously, I can't
display the entire table on a web page.
But even when I do an operation that displays just a
sing
