Thanks, adding the indexes worked beautifully. I'll go knock my head on
the desk now. Thanks for your time :)
Ed
Edward Ritter said the following on 7/20/2004 1:08 PM:
Thanks, I'll take a look at that. The id isn't unique, so that's why I
added the idx column.
Does my query look okay beyond tha
Thanks, I'll take a look at that. The id isn't unique, so that's why I
added the idx column.
Does my query look okay beyond that? I'll add the additional indexes and
try again.
Ed
Garth Webb said the following on 7/20/2004 1:03 PM:
What is the 'idx' for when you already have an 'id' column? Al
What is the 'idx' for when you already have an 'id' column? Also, you
need an index on the column that you are joining on; having a single
indexed column on a table doesn't automatically improve all queries
against that table. Put an index on the 'email_address' fields of both
tables. You'll ne
Stefan:
I added an index column to each after I imported. Here's a listing of
the two tables.
la_entire
++-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
++-+--+-+
I would expect that the speed problems are due to missing indices. Did you do
proper indexing? If unsure, post your table structures and query.
Stefan
Am Tuesday 20 July 2004 17:45 schrieb Edward Ritter:
> I've got a task that's gonna require me to compare one table to another
> and remove the ro
I've got a task that's gonna require me to compare one table to another
and remove the rows from the first table that are found in the second
table that match email_address.
I'm running 4.0.20a-nt-log. The first table has 10 colomns and about 50K
records, and the second table has 46 columns and