MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing July 2024 off-cycle Releases featuring MySQL Server 9.0.1 Innovation, 8.4.2 LTS and 8.0.39 07/24/2024 11:15AM
•   Announcing July 2024 Releases featuring MySQL Server 9.0.0 Innovation, 8.4.1 LTS and 8.0.38 07/02/2024 06:42AM

Advanced Search
New Topic
Pages:
« 1
...
15 16 17 18 19 »

Subject
Views
Written By
Posted
Two nearly equal querys, but very different performance  
2,981
Sven Markwart
09/12/2006 08:54AM
Re: Two nearly equal querys, but very different performance  
1,852
Toa Sty
09/12/2006 09:34AM
sometimes, mysql don't use an existing index  
6,273
Bart Peeters
09/04/2006 12:17PM
Re: sometimes, mysql don't use an existing index  
2,806
Toa Sty
09/11/2006 06:29AM
slow corelated subquery, not sure how to rewrite  
3,525
Tait Larson
09/01/2006 06:42PM
Re: slow corelated subquery, not sure how to rewrite  
2,018
Tait Larson
09/03/2006 12:00AM
Re: slow corelated subquery, not sure how to rewrite  
1,857
KimSeong Loh
09/10/2006 10:18PM
best way to create 'next' and 'previous' text  
2,613
Johannes Fosseus
09/10/2006 01:53AM
Re: best way to create 'next' and 'previous' text  
1,605
Bob Field
09/10/2006 09:01AM
Best index for my table  
3,213
Johannes Fosseus
09/09/2006 01:01AM
Re: Best index for my table  
1,799
Bob Field
09/09/2006 02:01PM
Re: Best index for my table  
1,753
Johannes Fosseus
09/10/2006 12:37AM
Why do mysql use temporary and filesort here?  
3,349
Johannes Fosseus
09/08/2006 04:50AM
Re: Why do mysql use temporary and filesort here?  
2,184
Björn Steinbrink
09/08/2006 06:36AM
slow selects  
2,744
Danie Van der Walt
08/31/2006 08:02AM
Re: slow selects  
1,876
Toa Sty
08/31/2006 08:43AM
Re: slow selects  
1,873
Danie Van der Walt
08/31/2006 09:06AM
Re: slow selects  
1,887
Toa Sty
09/01/2006 03:04AM
Re: slow selects  
1,835
Danie Van der Walt
09/01/2006 04:17AM
Re: slow selects  
2,109
Toa Sty
09/01/2006 04:50AM
Re: slow selects  
1,848
Danie Van der Walt
09/01/2006 07:24AM
Re: slow selects  
1,884
Toa Sty
09/01/2006 08:16AM
Re: slow selects  
1,882
Danie Van der Walt
09/02/2006 12:52PM
Query Optimization  
2,700
Will Buckner
08/21/2006 11:05AM
Re: Query Optimization  
1,707
Bill Karwin
08/21/2006 06:44PM
Re: Query Optimization  
1,719
Will Buckner
08/27/2006 11:50PM
Re: Query Optimization  
1,840
Anthony Willard
08/28/2006 07:33AM
Optimizing a UNION Query  
6,221
Charles Salvia
08/23/2006 08:16PM
Re: Optimizing a UNION Query  
2,678
Toa Sty
08/24/2006 05:28AM
Re: Optimizing a UNION Query  
2,721
Charles Salvia
08/24/2006 12:12PM
Re: Optimizing a UNION Query  
5,404
Toa Sty
08/25/2006 06:14AM
Re: Optimizing a UNION Query  
2,665
Toa Sty
08/24/2006 04:59AM
Really need help with optimization  
2,956
Anders Bergman
08/22/2006 01:43PM
Re: Really need help with optimization  
1,806
Toa Sty
08/23/2006 12:50AM
Re: Really need help with optimization  
1,894
Anders Bergman
08/23/2006 01:24PM
Re: Really need help with optimization  
1,818
Toa Sty
08/24/2006 04:53AM
Re: Really need help with optimization  
1,858
Anders Bergman
08/22/2006 01:46PM
Left Join Problem  
2,598
Clodelio Delfino
08/22/2006 11:30PM
Re: Left Join Problem  
1,782
Bob Field
08/23/2006 09:00AM
Re: Left Join Problem  
1,777
Clodelio Delfino
08/23/2006 06:53PM
Re: Left Join Problem  
1,704
Bob Field
08/23/2006 07:12PM
Re: Left Join Problem  
1,894
Clodelio Delfino
08/23/2006 11:01PM
optimizing the query.  
2,597
ronak desai
07/26/2006 07:13AM
Re: optimizing the query.  
1,850
Yogesh Salvi
08/22/2006 12:37PM
Re: optimizing the query.  
1,825
Toa Sty
08/04/2006 04:50AM
Re: optimizing the query.  
1,754
KimSeong Loh
07/27/2006 12:13AM
cant get LEFT JOIN to work properly when ORDER'ing BY  
2,323
Liutauras
08/20/2006 02:11AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
1,651
Liutauras
08/22/2006 03:26AM
cant get LEFT JOIN to work properly when ORDER'ing BY  
6,405
Liutauras
08/20/2006 01:36AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
8,445
Toa Sty
08/21/2006 07:25AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
4,070
Toa Sty
08/21/2006 07:55AM
Re: cant get LEFT JOIN to work properly when ORDER'ing BY  
2,980
Liutauras
08/22/2006 03:25AM
Force Table Selection Order in JOIN Statement?  
10,650
Frank Osterberg
08/21/2006 02:39AM
Re: Force Table Selection Order in JOIN Statement?  
9,696
Toa Sty
08/21/2006 06:24AM
ORDER BY RAND() taking too much time  
10,246
Yogesh Salvi
04/29/2006 05:30AM
Re: ORDER BY RAND() taking too much time  
3,829
Erin ONeill
06/08/2006 10:38AM
Re: ORDER BY RAND() taking too much time  
2,619
Yogesh Salvi
05/11/2006 04:25AM
Re: ORDER BY RAND() taking too much time  
3,144
Yogesh Salvi
05/03/2006 01:51AM
Re: ORDER BY RAND() taking too much time  
3,431
Ravenous Bugblatter Beast
08/15/2006 05:13PM
Re: ORDER BY RAND() taking too much time  
2,946
Yogesh Salvi
05/03/2006 02:11AM
Re: ORDER BY RAND() taking too much time  
4,109
Yogesh Salvi
05/02/2006 08:44AM
Re: ORDER BY RAND() taking too much time  
3,554
Björn Steinbrink
05/02/2006 02:24PM
Re: ORDER BY RAND() taking too much time  
3,814
Sebastien Caisse
05/01/2006 08:49AM
How to create on-the-fly index on derived table?  
12,503
Nathan Cheng
07/25/2006 01:05PM
Re: How to create on-the-fly index on derived table?  
7,346
Nathan Cheng
08/12/2006 03:04PM
difference performance of simple SELECT (on large tables) between MySql running on Windows XP and on Ubuntu  
2,870
Ed Stone
08/09/2006 03:48PM
EXISTS() optimization  
19,673
Rob Blick
06/07/2006 10:00AM
Re: EXISTS() optimization  
6,609
bill stamp
07/25/2006 07:54AM
Re: EXISTS() optimization  
5,627
Nathan Cheng
07/25/2006 01:13PM
Re: EXISTS() optimization  
5,263
Toa Sty
08/04/2006 04:45AM
Too many rows being read  
2,919
preston
08/02/2006 02:02PM
Re: Too many rows being read  
1,745
Bob Field
08/02/2006 02:18PM
Why does this query filesort?  
2,769
Jim Daemon
07/27/2006 12:05PM
Re: Why does this query filesort?  
1,831
KimSeong Loh
08/01/2006 11:14PM
optimize dynamic sql  
3,540
Bhupesh Tripathi
07/28/2006 03:33AM
query of tables with a longblob  
2,547
paul obyrne
06/23/2006 11:44AM
Re: query of tables with a longblob  
1,730
Nathan Cheng
07/25/2006 01:26PM
Optimizing (a=b and c=d) OR (e=f and g=h)  
2,672
a.h.s. boy
07/20/2006 12:07PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,785
KimSeong Loh
07/20/2006 05:29PM
Re: Optimizing (a=b and c=d) OR (e=f and g=h)  
1,752
a.h.s. boy
07/20/2006 10:09PM
With vs Without Primary Key in a particular case  
6,984
Martin Feng
07/19/2006 11:02PM
Re: With vs Without Primary Key in a particular case  
2,856
KimSeong Loh
07/20/2006 05:35PM
SELECT DISTINCT vs UNIQUE KEY  
10,314
Martin Feng
07/19/2006 06:11AM
LEFT JOIN problem  
3,425
Steve Jordi
07/17/2006 07:13AM
Re: LEFT JOIN problem  
1,831
Peter Brawley
07/17/2006 08:07AM
Re: LEFT JOIN problem  
1,784
Steve Jordi
07/17/2006 09:30AM
Re: LEFT JOIN problem  
1,788
Peter Brawley
07/17/2006 12:03PM
Re: LEFT JOIN problem  
1,721
Steve Jordi
07/17/2006 10:23PM
(How) are subqueries optimized involving the same table?  
2,701
Jakobus Dornier
07/13/2006 08:02AM
Re: (How) are subqueries optimized involving the same table?  
1,948
Jakobus Dornier
07/13/2006 08:20AM
Re: (How) are subqueries optimized involving the same table?  
1,790
Bob Field
07/13/2006 08:33AM
Re: (How) are subqueries optimized involving the same table?  
1,987
Jakobus Dornier
07/13/2006 08:40AM
Re: (How) are subqueries optimized involving the same table?  
1,805
Bob Field
07/13/2006 08:53AM
Re: (How) are subqueries optimized involving the same table?  
1,733
Jakobus Dornier
07/13/2006 08:57AM
Re: (How) are subqueries optimized involving the same table?  
1,960
Bob Field
07/13/2006 08:12AM
How to get some documents or articles on the query optimization of MySQL????  
2,459
Hui Sun
07/10/2006 07:10AM
Re: How to get some documents or articles on the query optimization of MySQL????  
1,805
KimSeong Loh
07/10/2006 05:12PM
min() vs limit optimization  
5,539
Paul Medynski
07/02/2006 05:34PM
Re: min() vs limit optimization  
2,227
Apachez
07/02/2006 08:26PM
Re: min() vs limit optimization  
2,165
Paul Medynski
07/03/2006 05:22PM
Re: min() vs limit optimization  
2,323
Apachez
07/04/2006 06:51AM
Slow Union Query Opimization. Need help.  
6,312
Roland Meier
06/29/2006 12:50AM
Re: Slow Union Query Opimization. Need help.  
2,583
Jay Pipes
06/29/2006 04:53PM
Re: Slow Union Query Opimization. Need help.  
2,951
Roland Meier
06/30/2006 02:30AM
Re: Slow Union Query Opimization. Need help.  
3,203
Anthony Willard
06/29/2006 08:24AM
querying time is too high  
2,898
trinath somanchi
06/27/2006 07:31AM
Re: querying time is too high  
1,923
Anthony Willard
06/29/2006 08:52AM
Re: querying time is too high  
1,917
trinath somanchi
06/29/2006 12:48AM
Re: querying time is too high  
1,964
Jim Daemon
06/28/2006 10:00AM
Boolean search and 99% cpu  
2,427
Taiyo Rai
06/27/2006 07:17AM
Joining several multi-to-multi tables  
3,660
adambrill1986
06/20/2006 11:59AM
Re: Joining several multi-to-multi tables  
2,060
adambrill1986
06/23/2006 06:58AM
Re: Joining several multi-to-multi tables  
1,986
adambrill1986
06/20/2006 12:21PM
Re: Joining several multi-to-multi tables  
1,956
adambrill1986
06/20/2006 01:44PM
Re: Joining several multi-to-multi tables  
1,927
Bill Karwin
06/20/2006 04:23PM
Re: Joining several multi-to-multi tables  
1,919
KimSeong Loh
06/20/2006 06:02PM
Re: Joining several multi-to-multi tables  
1,904
Bill Karwin
06/20/2006 01:02PM
Re: Joining several multi-to-multi tables  
1,910
Bill Karwin
06/20/2006 12:14PM
no optimization?  
2,529
Uwe
05/22/2006 05:47AM
Re: no optimization?  
1,868
Apachez
06/18/2006 08:50PM
Re: no optimization?  
1,838
Uwe
06/21/2006 10:40AM
Regression: Query optimized in 4.1, not at all in 5.0, why?  
2,559
William Shubert
06/21/2006 12:35AM
Re: Regression: Query optimized in 4.1, not at all in 5.0, why?  
1,785
William Shubert
06/21/2006 12:36AM
RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
5,029
Ijaz Rashid
06/20/2006 07:06AM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
2,187
Bill Karwin
06/20/2006 12:18PM
Re: RollOver one table - having 10millin records - Still 100,000 insertion/sec at bottom - Need to delete 30,00,000 records in 1second after every 30 min  
2,322
Ijaz Rashid
06/20/2006 07:18AM
Why does this delete statement take so long?  
5,131
Jim Daemon
06/15/2006 02:11PM
Re: Why does this delete statement take so long?  
2,095
Bob Field
06/15/2006 03:56PM
Re: Why does this delete statement take so long?  
2,024
Jim Daemon
06/15/2006 04:16PM
Why isn't the index being used?  
3,381
Jim Daemon
06/12/2006 06:11PM
Re: Why isn't the index being used?  
1,973
Jim Daemon
06/13/2006 04:03PM
Re: Why isn't the index being used?  
1,967
Jim Daemon
06/13/2006 09:54AM
Re: Why isn't the index being used?  
1,920
KimSeong Loh
06/13/2006 10:34AM
Re: Why isn't the index being used?  
1,948
Bob Field
06/13/2006 09:11AM
Re: Why isn't the index being used?  
2,168
Jim Daemon
06/13/2006 08:41AM
Re: Why isn't the index being used?  
1,917
Bob Field
06/12/2006 06:41PM
How to avoid temporary and filesort?  
5,952
Jim Daemon
06/13/2006 08:49AM
Re: How to avoid temporary and filesort?  
3,201
KimSeong Loh
06/13/2006 09:06AM
Re: How to avoid temporary and filesort?  
3,381
Jim Daemon
06/13/2006 09:39AM
Re: How to avoid temporary and filesort?  
2,783
KimSeong Loh
06/13/2006 10:31AM
How to avoid filesort  
12,624
Jim Daemon
06/11/2006 06:50PM
Re: How to avoid filesort  
6,206
Jim Daemon
06/12/2006 01:30PM
Re: How to avoid filesort  
6,933
KimSeong Loh
06/12/2006 08:40AM
Re: How to avoid filesort  
6,171
Jim Daemon
06/12/2006 09:10AM
Help with optimizing GROUP BY query  
5,095
lasse
06/12/2006 07:16AM
Re: Help with optimizing GROUP BY query  
2,563
KimSeong Loh
06/12/2006 08:37AM
Re: Help with optimizing GROUP BY query  
2,469
lasse
06/12/2006 10:54AM
Re: Help with optimizing GROUP BY query  
2,477
KimSeong Loh
06/12/2006 01:01PM
Why is FULLTEXT index not used with a LEFT JOIN?  
4,018
Tad Woods
06/11/2006 10:29AM
Re: Why is FULLTEXT index not used with a LEFT JOIN?  
2,188
Tad Woods
06/11/2006 03:39PM
fast way to delete records?  
14,246
ylu
05/23/2006 03:35PM
Re: fast way to delete records?  
6,152
KimSeong Loh
05/24/2006 06:43PM
Re: fast way to delete records?  
4,504
tri.truong
06/08/2006 12:30PM
Re: fast way to delete records?  
6,747
Anthony Willard
05/24/2006 07:29AM
Will sort help optimizing this query?  
2,879
binglew
06/08/2006 11:27AM
count(*) versus mysql_num_rows  
28,207
nachomonterde
11/21/2005 03:54PM
Re: count(*) versus mysql_num_rows  
5,642
Rob Blick
06/08/2006 09:41AM
Re: count(*) versus mysql_num_rows  
8,089
Paul Loy
06/02/2006 04:13AM
Re: count(*) versus mysql_num_rows  
9,130
Alexandru Cristescu
11/24/2005 05:55AM
Re: count(*) versus mysql_num_rows  
7,478
Jacky Shu
11/24/2005 09:18AM
Selecting a proper table stucture  
3,258
Daniel Misio
06/07/2006 04:07AM
Re: Selecting a proper table stucture  
2,004
Anthony Willard
06/07/2006 09:47AM
Slow Database  
9,211
Dominic Hayhoe
05/31/2006 11:29AM
Re: Slow Database  
3,419
Dominic Hayhoe
06/01/2006 04:14AM
Re: Slow Database  
2,588
KimSeong Loh
06/01/2006 06:40PM
Re: Slow Database  
2,980
Dominic Hayhoe
06/02/2006 02:17AM
Re: Slow Database  
2,821
KimSeong Loh
06/05/2006 10:37AM
Re: Slow Database  
2,675
KimSeong Loh
05/31/2006 07:43PM
Re: Slow Database  
2,632
Dominic Hayhoe
06/01/2006 12:19AM
Re: Slow Database  
3,550
Peter Brawley
05/31/2006 12:06PM
Re: Slow Database  
2,844
Dominic Hayhoe
05/31/2006 12:43PM
Help to optimize my query  
2,355
björn spiegel
06/04/2006 09:34AM
Optimizing query with multiple joins  
4,870
EM Ayllon
05/29/2006 05:07AM
Re: Optimizing query with multiple joins  
2,296
EM Ayllon
05/30/2006 07:15AM
Re: Optimizing query with multiple joins  
2,428
Peter Brawley
05/29/2006 08:36AM
Pages:
« 1
...
15 16 17 18 19 »

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.