I'm trying to start a connection to a mysql database, but even though
I've installed the connector I don't see where the option to choose that
data type of connection exists.
I'm using Connection/NET v 5.1, btw
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Awesome, thanks. My first attempt is able to run on the full table in
85 seconds. I'll continue to read up on these queries to see if I can
optimize it further.
Thanks again.
Peter Brawley wrote:
Kip,
> What can I do to optimize this query?
For more efficient alternatives see "Within-gr
Kip,
> What can I do to optimize this query?
For more efficient alternatives see "Within-group aggregates" at
http://www.artfulsoftware.com/queries.php.
PB
-
Kip Turk wrote:
I'm having problems optimizing a series of subselects. I have the
following sample table:
mysql> select * fr
I'm having problems optimizing a series of subselects. I have the
following sample table:
mysql> select * from fake order by msgid, id desc;
++---+-+-+
| id | msgid | nec | dt |
++---+-+-+
| 10 | 1 | 300 | 2008
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2008 10:55 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Very large temporary file(s)
True, if you explicitly use group by and order by, there would a group
operation after which sorting happens, but the same
True, if you explicitly use group by and order by, there would a group
operation after which sorting happens, but the same would happen if you use
just "GROUP BY". That how mysql works.
On 6/25/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
>
>*From:* Ananda Kumar [mailto:[EMAIL PROTECTED]
> *S
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 10:50 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Very large temporary file(s)
In mysql, GROUP BY also by default does sorting using "ORDER BY", so you an
avoid it by including "ORDER BY NULL" after GROU
