Chris, this should already be pretty fast as it is using a primary key in
its entirety, and as long as the index size remains manageable MySQL will be
able to keep it in memory for fast access.
That said, doing away with the aggregate function might speed things up just
slightly.
You don't care h
I was wondering if someone could tell me what things I might need to do
to make this query as fast as possible.
I am developing a web site where users will have access to certain
things based on what groups they are in and what groups have access to
certain things. There are several different
On Thu, Aug 21, 2003 at 01:03:16AM +, gord barq wrote:
> I have this query which does a left outer join and it takes forever (like
> half a day). Here are the results of an explain analysis.
>
> mysql> explain SELECT count(searchresult.title) AS number,
> campaigntrack.title, tracknum, track
gord barq wrote:
I have this query which does a left outer join and it takes forever
(like half a day). Here are the results of an explain analysis.
mysql> explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER
JOIN searchresult
I have this query which does a left outer join and it takes forever (like
half a day). Here are the results of an explain analysis.
mysql> explain SELECT count(searchresult.title) AS number,
campaigntrack.title, tracknum, trackid FROM campaigntrack LEFT OUTER JOIN
searchresult ON searchresult.t
;[EMAIL PROTECTED]>
Sent: Saturday, 07 June, 2003 17:28
Subject: Re: Trouble optimizing a query
On Sat, 7 Jun 2003 15:33 , Paul DuBois <[EMAIL PROTECTED]> sent:
>
>This is a problem that is fixed in MySQL 4. If you can upgrade, that
>should help you a lot.
>
>http://www
On Sat, 7 Jun 2003 15:33 , Paul DuBois <[EMAIL PROTECTED]> sent:
>
>This is a problem that is fixed in MySQL 4. If you can upgrade, that
>should help you a lot.
>
>http://www.mysql.com/doc/en/News-4.0.0.html
>
That explains that. I was relying on the online docs and it didn't even
occur to me
At 22:29 +0200 6/7/03, <[EMAIL PROTECTED]> wrote:
Hello everyone,
I'm working with MySQL 3.23.41-log developing a chat application. I
need to run a query, order the results in
descending order, then get the last 0-15 entries that are less than
20 minutes old. The query and tables in question
a
Hello everyone,
I'm working with MySQL 3.23.41-log developing a chat application. I need to run a
query, order the results in
descending order, then get the last 0-15 entries that are less than 20 minutes old.
The query and tables in question
are explained at the bottom of this posting. In
I need to optimize the following query:
SELECT user, sum(in), sum(out) FROM stats WHERE from>='20020205'
AND to<='20020206' GROUP BY user;
In,out are bigint, user is varcher(20) and from,to are timestamp
And I want to speed up this type of query, but I have not been able to
to get it to use an
I need to optimize the following query:
SELECT user, sum(in), sum(out) FROM stats WHERE from>='20020205'
AND to<='20020206' GROUP BY user;
In,out are bigint, user is varcher(20) and from,to are timestamp
And I want to speed up this type of query, but I have not been able to
to get it to use an
Hi all.
I want to optimize a query that is executed often in the application we use
at work.
NOTE: Excuse me for using spanish names for the tables and the columns.
In the database we have three tables for article: ARTICULOINFO (information
of an article), LARTICULOINFO_IDIOMA (information of a
12 matches
Mail list logo
