Hello.
On Tue, Feb 20, 2001 at 03:27:08PM -0800, [EMAIL PROTECTED] wrote:
Huh? You got it 7 times faster by only extracting that query from the
for loop and changing it to a group by? Or did you do anything else?
Sorry there were some other unnecessary queries that were mistakenly
in the
Hi.
On Wed, Feb 21, 2001 at 12:32:21PM -0800, [EMAIL PROTECTED] wrote:
I will respond in more detail later but just quickly now :
Hm. Sorry, I don't understand your argument. By the for loop, your
query does the same, doesn't it (selecting the rank of one album in
each metro is the
Huh? You got it 7 times faster by only extracting that query from the
for loop and changing it to a group by? Or did you do anything else?
Sorry there were some other unnecessary queries that were mistakenly in the
measurement..
Here is the missing EXPLAIN.
mysql EXPLAIN SELECT
Hello.
On Fri, Feb 16, 2001 at 03:58:20PM -0800, [EMAIL PROTECTED] wrote:
This is the latest approach we're using now. It turns out that the
query to get Total Plays for an Album per City can be taken out of
the City for loop done only once as a GROUP BY. The worst case
time for MySQL is
This is the latest approach we're using now. It turns out that the query to get Total
Plays for an Album per City can be taken out of the City for loop done only once as
a GROUP BY.
The worst case time for MySQL is now 16 seconds compared to Oracle's 8 seconds. On
most cases MySQL is now
Hi.
Could you please post the result of "EXPLAIN" for both queries and
"SHOW INDEX FROM album_by_city".
And, for how much cities does this gets executed?
Additionally, I would be interested, if you used the same method with
Oracle or another. If so, would you please post it, too.
Bye,
Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM
album_by_city".
I haven't used EXPLAIN before.
There are indexes on each column.
And, for how much cities does this gets executed?
There are about 100 cities or regions that are used for ranking.
Hi.
On Thu, Feb 15, 2001 at 09:25:56PM -0800, [EMAIL PROTECTED] wrote:
Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX
FROM album_by_city".
I haven't used EXPLAIN before.
Just put it before the SELECT in your query. I don't know whether this
will work