Click here to Skip to main content
15,914,481 members
Home / Discussions / Web Development
   

Web Development

 
QuestionRe: picture not shown in runtime (.net) Pin
Adam Maras27-Aug-09 23:22
Adam Maras27-Aug-09 23:22 
AnswerRe: picture not shown in runtime (.net) Pin
m.samar28-Aug-09 17:55
m.samar28-Aug-09 17:55 
QuestionHow to get printer status and print MS word document using javascript? Pin
Gokul Raja198724-Aug-09 6:03
Gokul Raja198724-Aug-09 6:03 
AnswerRe: How to get printer status and print MS word document using javascript? Pin
sunfruit25-Nov-10 20:50
sunfruit25-Nov-10 20:50 
QuestionHow to get MS word document page settings and number of pages using JavaScript? Pin
Gokul Raja198724-Aug-09 5:49
Gokul Raja198724-Aug-09 5:49 
AnswerRe: How to get MS word document page settings and number of pages using JavaScript? Pin
Gokul Raja198717-Sep-09 8:25
Gokul Raja198717-Sep-09 8:25 
QuestionHow to kill the process of website in c# Pin
Rajesh_K_Sharma24-Aug-09 0:28
Rajesh_K_Sharma24-Aug-09 0:28 
AnswerRe: How to kill the process of website in c# Pin
SeMartens24-Aug-09 20:40
SeMartens24-Aug-09 20:40 
Questionhow can i send a byte array from client side to server side Pin
subramanian.rtechconet23-Aug-09 23:00
subramanian.rtechconet23-Aug-09 23:00 
QuestionDisable Print Screen Option Pin
Aman Bhullar21-Aug-09 20:13
Aman Bhullar21-Aug-09 20:13 
QuestionDrawing a box around an arbitrary HTML block Pin
astibich221-Aug-09 15:00
astibich221-Aug-09 15:00 
QuestionElegant use of the CSS padding property Pin
jesarg21-Aug-09 8:03
jesarg21-Aug-09 8:03 
AnswerRe: Elegant use of the CSS padding property Pin
jesarg21-Aug-09 8:10
jesarg21-Aug-09 8:10 
Question"best" Blog for text publishing ? Pin
Maximilien21-Aug-09 5:21
Maximilien21-Aug-09 5:21 
AnswerRe: "best" Blog for text publishing ? Pin
msn9221-Aug-09 8:18
msn9221-Aug-09 8:18 
AnswerRe: "best" Blog for text publishing ? Pin
Jeremy Likness27-Aug-09 6:28
professionalJeremy Likness27-Aug-09 6:28 
QuestionDisable the image from being saved on client machine Pin
Coding C#21-Aug-09 4:20
Coding C#21-Aug-09 4:20 
AnswerRe: Disable the image from being saved on client machine Pin
msn9221-Aug-09 8:25
msn9221-Aug-09 8:25 
GeneralRe: Disable the image from being saved on client machine Pin
Coding C#23-Aug-09 19:38
Coding C#23-Aug-09 19:38 
GeneralRe: Disable the image from being saved on client machine Pin
Joe Simes1-Sep-09 8:28
Joe Simes1-Sep-09 8:28 
Questionadding web service from ftp Pin
Maverickcool21-Aug-09 3:22
Maverickcool21-Aug-09 3:22 
QuestionHelp in creating Web Bot Pin
kc_krishnan20-Aug-09 22:55
kc_krishnan20-Aug-09 22:55 
AnswerRe: Help in creating Web Bot Pin
Ashfield21-Aug-09 1:35
Ashfield21-Aug-09 1:35 
Questioninversing an inner join without using left join Pin
mark_me20-Aug-09 14:22
mark_me20-Aug-09 14:22 
AnswerRe: inversing an inner join without using left join Pin
Ashfield20-Aug-09 21:31
Ashfield20-Aug-09 21:31 
If you are sure your sql is correct (and it does look OK to me) and your problem is actually the query timing out, how about either increase the query timeout (not sure how on MYSQL, but its probably part of the connection properties) or, better still, have a look at the indices. The table sizes your quote are very small, I would expect any database system to handle this volume of data with ease, but not if you are missing indices for your joins and there are tablescans going on.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.