Help tuning a very poor SQL query

Help tuning a very poor SQL query

El Forum
Guest

#15

06-18-2009, 10:14 AM

[eluser]TheFuzzy0ne[/eluser]
Any reason why you need 20 random rows? That could be a serious performance issue. If you can give more details on what you need to do, there may be a better solution. What's the maximum number of rows you expect to have in your table?

Messages In This Thread

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 08:03 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 08:19 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 08:24 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 09:42 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 09:47 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 10:10 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 10:28 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 11:21 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 11:40 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 11:49 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 05:49 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 05:53 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 06:02 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 09:57 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 10:14 AM