Welcome Guest, Not a member yet? Register   Sign In
SQL [Advanced, I think...]
#2

[eluser]NotDior[/eluser]
Have you already used 'EXPLAIN SELECT....." on your query to see what it's using to search and the path it takes? I found that to help a bit on some of my queries and by putting in some indexes it helped out things quite a bit.


Messages In This Thread
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 02:33 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 02:44 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 03:28 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 03:33 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 08:48 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 09:53 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 11:07 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 11:11 PM
SQL [Advanced, I think...] - by El Forum - 07-20-2012, 05:51 AM
SQL [Advanced, I think...] - by El Forum - 07-20-2012, 08:11 AM



Theme © iAndrew 2016 - Forum software by © MyBB