isits_1.visit_number=1
AND visits_2.visit_number=2
AND
UNIX_TIMESTAMP(visits_2.date_time_visit)-UNIX_TIMESTAMP(visits_1.date_time_v
isit) <= 3600
GROUP BY dt
LIMIT 0,50
Just interested to know,
Bruce
-Original Message-
From: Nick Kostirya [mailto:[EMAIL PROTECTED]]
Sent: Tue, 26 June 200
On Tue, 26 Jun 2001 16:08, Nick Kostirya wrote:
> Hi, All.
> Help me to understand why such different speed of two queries. These
> queries do the same and differ only in superfluous information (marked
> by red). Speed of the first is 0.37 second. Speed of the latter is 3.95
> second.
> Best R
Hi, All.
Help me to understand why such different speed of two queries. These queries do the
same and differ only in superfluous information (marked by red). Speed of the first is
0.37 second. Speed of the latter is 3.95 second.
The first:
SELECT DATE_FORMAT(visits_1.date_time_visit, '%Y-%m-%d
