On Wed, 2001-12-05 at 16:33, Arjen G. Lentz wrote:
>
> - Original Message -
> From: "Florin Andrei" <[EMAIL PROTECTED]>
>
> > SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
> > event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
> > tcphdr.cid AND tcphdr
On Thu, Dec 06, 2001 at 09:39:18AM +1000, Arjen G. Lentz wrote:
> Well, you have to realise that the server can only use a one index
> per table (for obvious reasons).
That's far from being obvious to a lot of folks...
> You can actually split a table into multiple identical ones, by
> using ME
Hi again Florin,
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
> SELECT event.cid, iphdr.ip_src, iphdr.ip_dst, tcphdr.tcp_dport FROM
> event, iphdr, tcphdr WHERE event.cid = iphdr.cid AND event.cid =
> tcphdr.cid AND tcphdr.tcp_flags = '2';
Your only search condition i
Hi Florian,
- Original Message -
From: "Florin Andrei" <[EMAIL PROTECTED]>
> I have this SQL query:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
> tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
> (well, maybe there are more than two columns selected, and maybe a
> little more t
Florin Andrei writes:
> SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
> tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
>
> The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> it run over night, in the morning i still didn't got any results, so i
> killed the query).
On Wed, 2001-12-05 at 15:01, Robert Alexander wrote:
> At 14:45 -0800 2001/12/05, Florin Andrei wrote:
> >The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
> >it run over night, in the morning i still didn't got any results, so i
> >killed the query).
>
> the hardware and
At 14:45 -0800 2001/12/05, Florin Andrei wrote:
>The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let
>it run over night, in the morning i still didn't got any results, so i
>killed the query).
Hi Florin,
It would help if you could also provide:
the hardware and OS
the a
I have this SQL query:
SELECT tbl1.col1, tbl2.col2 FROM tbl1, tbl2 WHERE \
tbl1.col3 = tbl2.col4 AND tbl1.col5 = '123';
(well, maybe there are more than two columns selected, and maybe a
little more than two tables, but you got the idea...)
The tables have 5...10 columns, every column is an in
