KE '%/'
)
And
logs_2006_11.int_bots = 0
And
(
cs_documents.str_url NOT LIKE '/phpadsnew/%'
)
And
logs_2006_11.date >= '2006-11-01'
And
logs_2006_11.date <= '2006-11-05'
And
logs_2006_11.time >= '00:00:00'
And
logs_2006_11.t
ws to complete
You may want to store the file extension as a separate field
in this table and index it. Then change your query accordingly.
- Original Message -
From: Francis <[EMAIL PROTECTED]>
To: Rolando Edwards <[EMAIL PROTECTED]>
Cc: MySQL General
Sent: Monday, November
cuments', 'eq_ref', 'id', 'id', 3,
'trafix_sites_00026.logs_2006_11.int_url_strem', 1, 'Using where'
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:54 AM
To: Francis
the SQL statement to
verify row counts on all intermittent steps
- Original Message -
From: Francis <[EMAIL PROTECTED]>
To: Rolando Edwards <[EMAIL PROTECTED]>
Cc: MySQL General
Sent: Monday, November 6, 2006 9:31:32 AM GMT-0500 US/Eastern
Subject: RE: " Copy to tmp tabl
int_search tinyint(3) unsigned NOT NULL default '0',
int_platforms smallint(5) unsigned NOT NULL default '0',
int_bots tinyint(3) unsigned NOT NULL default '0',
int_host tinyint(3) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY ip (`in
You need to look at the GROUP BY clause
If all the columns from a GROUP BY clause
are not indexed or if the columns in the
GROUP BY clause are from different tables,
MySQL will use the temp table.
Please send your query to the MySQL List
and the structure of all tables in the query
- Origina
