|
+-+--+
1 row in set (0.00 sec)
I know this may not match directly to your data situation but you offered
few specifics. Hope it helps.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Eric
Scuccimarra
<
I have a table where one field is a long list of numbers in comma-delimited
format.
I need to do a query like:
SELECT *
FROMTable
WHERE [number] IN list
If I cut and paste the actual list in it works fine but when I use the
column-name containing the list it returns nothing. I've
We have a table with a Date Time field and we need to update only the date
portion of that field.
We have table a with field Foo with value '2004-01-01 12:15:00' and a date
'2004-03-01' and we need to change the date portion of Foo to the date and
leave the time part alone.
So Foo would change
For anyone who is interested the thing that worked and brought the query
down from 8 minutes to 5 seconds was separating out the JOIN to remove the
OR. I made it into two queries and UNIONed them together and it all works
beautifully now.
Thanks.
At 02:33 PM 2/25/2004 -0800, Daniel Clark wrote
Have one more question - indexing the relevant columns based on the explain
info has made all of our queries immensely faster.
But it appears that new rows are not automatically indexed. Does anyone
know about this and if they are not indexed how do I reindex the tables?
Thanks.
--
MySQL Gen
Tried to make the indexes separate and did an EXPLAIN and no performance
increase and this is what the explain says:
id select_type table typepossible_keys
key key_len ref rowsExtra
1 SIMPLE tb ALL PRIMARY,tb_ndx3,tb_ndx4,tb_ndx5
NULLNU
No, we tried individual indexes and then one big grouped index but not
individual indexes on each of the fields. Adding the index actually added a
few seconds to the query so we weren't sure if that was the way to go.
I'll try this, though.
Eric
At 10:36 AM 2/25/2004 -0800, Daniel Clark wrote:
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
T
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
T
