Thanks to all,
As you says me, the solution was the indexes. I didn't have an index
in results.sample_id. Now the query returns succesfully in a few
seconds, regards
Juan P. Espino
On 7/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Juan Pablo Espino <[EMAIL PROTECTED]> wrot
Juan Pablo Espino <[EMAIL PROTECTED]> wrote on 07/08/2005 03:37:14 PM:
> Hello all!
>
> I have two tables in my database: results(20 000 rows) and
> data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
> I need to find the samples of data_lab1 table that they are not in
> resul
Hello.
Check that MySQL doesn't hang, and that your system doesn't swap.
You can connect to MySQL server and check with 'SHOW PROCESSLIST'
states of MySQL threads. See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
Juan Pablo Espino <[EMAIL PROTECTED]> wrote:
> Hello all
o get it if people don't have to spend time figuring out what
the question is.
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 3:37 AM
Subject: Re:
;re
more likely to get it if people don't have to spend time figuring out what
the question is.
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 3:37
OK, I'm coming back to this problem after not touching it for a while.
Sorry about the indentation, it's a dynamically generated query and I just
cut and pasted into the email.
I tried your suggestion, and it is showing the correct number of displays
for most ads, but it is not limiting the cl
Shalom, Lisi,
(Sure would have been nice if you had indented and simplified your
SQL statements so they could be read by a mere human instead of
just by a computer ;-})
You have
SELECT ...
FROM display
LEFT JOIN click
ON display.name=click.name
AND ...
AND DAYOFMONTH(dis
* ds
> > Hi, please help me with this problem...
> >
> > Suppose i have a table whith ids and two more tables with logs like
> > this:
> >
> > table0: id1,id2
> > table1: id1,id2,date,ip
> > table2: id1,id2,date,ip
> >
> > Table0 is where i have all existent pairs (id1,id2).
> > Table1 logs all ev
At 12:57 PM -0700 11/15/01, Mark A Ohrenschall wrote:
>I'm having a problem with Distrib 3.23.42 with the following query:
>
>select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
>
>I'm finding that a left join on datetime fields that do not allow nulls is not
>working when I'
