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
- Original Message -
From: Francis <[EMAIL PROTECTED]>
To: MySQL General
Sent: Monday, November 6, 2006 8:50:40 AM GMT-0500 US/Eastern
Subject: " Copy to tmp table " optimize
Hi list,
An others question, I am working on projet and i made some test.
I use large databases, som
Hi list,
An others question, I am working on projet and i made some test.
I use large databases, some table go up to 1.8g. The problem we have is
wend I try to select data in table whit a group by function and I got "
Copy to tmp table " This function take a long time to execute. I check
o
