MySQL Help

23,055 topics in this forum

1. Optimal Table configuration?

   By pontifex, March 21, 2007
   • 5 replies
   • 1.1k views
   • 
   • fenway
   • April 4, 2007

2. Optimal table order for mySQL "join style" query

   By ChenXiu, July 4, 2023
   • 2 replies
   • 774 views
   • 
   • gizmola
   • July 4, 2023

3. Optimal Table Structure for league game stats

   By falltime, October 3, 2007
   • 5 replies
   • 1.4k views
   • 
   • TheFilmGod
   • October 4, 2007

4. Optimise Join Query

   By a1amattyj, October 26, 2011
   • 3 replies
   • 1.2k views
   • 
   • fenway
   • October 27, 2011

5. optimise LEFT JOIN ?

   By adhok, October 10, 2003
   • 2 replies
   • 1.9k views
   • 
   • adhok
   • October 16, 2003

6. Optimise Query

   By isedeasy, January 19, 2011
   • 13 replies
   • 1.9k views
   • 
   • fenway
   • February 17, 2011

7. Optimise Tables

   By New Coder, March 11, 2009
   • 5 replies
   • 1.6k views
   • 
   • Mchl
   • March 11, 2009

8. Optimising

   By Sephiriz, November 5, 2003
   • 1 reply
   • 1.6k views
   • 
   • shivabharat
   • November 7, 2003

9. Optimising Query

   By dweb, March 27, 2013
   • 3 replies
   • 756 views
   • 
   • fenway
   • March 30, 2013

10. Optimising query with count, group by and order by

    By ibinod, March 20, 2011
    • 1 reply
    • 797 views
    • 
    • The Little Guy
    • March 21, 2011

11. Optimising Script

    By esport, March 10, 2011
    • 1 reply
    • 609 views
    • 
    • requinix
    • March 10, 2011

12. optimization for a 1 gigabyte table - split into 2?

    By scarhand, March 27, 2009
    • 4 replies
    • 1k views
    • 
    • corbin
    • March 27, 2009

13. Optimization problem?

    By Shirik, March 28, 2007
    • 3 replies
    • 906 views
    • 
    • fenway
    • April 4, 2007

14. Optimize count query

    By Scooby08, July 13, 2012
    • 6 replies
    • 1.3k views
    • 
    • Scooby08
    • July 16, 2012

15. Optimize Join Query

    By a1amattyj, February 26, 2012
    • 2 replies
    • 813 views
    • 
    • fenway
    • March 5, 2012

16. Optimize Query

    By Psycho, November 22, 2006
    • 6 replies
    • 2.1k views
    • 
    • fenway
    • November 26, 2006

17. Optimize query

    By jaymc, March 1, 2007
    • 6 replies
    • 1.3k views
    • 
    • fenway
    • March 2, 2007

18. Optimize Query

    By The Little Guy, March 16, 2011
    • 3 replies
    • 724 views
    • 
    • kickstart
    • March 17, 2011

19. Optimize query

    By The Little Guy, September 5, 2008
    • 18 replies
    • 2.2k views
    • 
    • Mchl
    • September 6, 2008

20. optimize query (4 subqueries)

    By tail, January 26, 2010
    • 2 replies
    • 709 views
    • 
    • tail
    • January 28, 2010

21. Optimize table after every delete?

    By Jaguar, June 27, 2007
    • 2 replies
    • 1.4k views
    • 
    • fenway
    • June 27, 2007

22. Optimize/Speed Up Query

    By a1amattyj, January 29, 2012
    • 5 replies
    • 824 views
    • 
    • fenway
    • January 30, 2012

23. Optimized or not?

    By ergecs, April 8, 2008
    • 7 replies
    • 1.2k views
    • 
    • fenway
    • April 9, 2008

24. Optimized way of searching for users' locations at a given date

    By SirRealism, March 5, 2010
    • 0 replies
    • 468 views
    • 
    • SirRealism
    • March 5, 2010

25. Optimizing & Squeezing IDs

    By drath, September 16, 2010
    • 9 replies
    • 1.3k views
    • 
    • fenway
    • September 25, 2010