Gabriel PREDA wrote:
The JOIN criteria was there: 'event.cid=data.cid'
It was not there in the upper example he gave where he stated the problem.
It was there in the later query he said he also tried.
His query was fine: Select event.cid, event.timestamp from event, data
Where ( event.time
The JOIN criteria was there: 'event.cid=data.cid'
His query was fine: Select event.cid, event.timestamp from event, data
Where ( event.timestamp between '2006-05-01' AND '2006-05-15' ) and
event.cid=data.cid;
It may be rewritten into:
SELECT event.cid, event.timestamp
FROM event JOIN data ON ev
OTECTED]>
To:
Sent: Tuesday, July 11, 2006 6:13 PM
Subject: Trying to understand why Select running out of memory if table not used
When I try to retrieve all rows in the event table that are in a
particular range and then
try to determine if the cid is in the data table the join takes
for
When I try to retrieve all rows in the event table that are in a
particular range and then
try to determine if the cid is in the data table the join takes
forever.
So I tried just tried adding the table to see if the where clause was
slowing things down. Below is a portion on my session.
mys
