Click here to Skip to main content
15,891,811 members
Home / Discussions / Web Development
   

Web Development

 
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

GeneralRe: inversing an inner join without using left join Pin
mark_me21-Aug-09 6:10
mark_me21-Aug-09 6:10 
QuestionDisplaying a "wait" page while a CGI script executes? Pin
Sylv3320-Aug-09 6:54
Sylv3320-Aug-09 6:54 
QuestionJavascript - change dropdown.selectedIndex to selectedIndex from other dropdown Pin
CareyGrant20-Aug-09 6:22
CareyGrant20-Aug-09 6:22 
AnswerRe: Javascript - change dropdown.selectedIndex to selectedIndex from other dropdown Pin
CareyGrant20-Aug-09 6:26
CareyGrant20-Aug-09 6:26 
Questionasp/html/javascript Pin
rajiv_kadam19-Aug-09 23:43
rajiv_kadam19-Aug-09 23:43 
AnswerRe: asp/html/javascript Pin
Ashfield20-Aug-09 1:37
Ashfield20-Aug-09 1:37 
Questionshow/hide div Pin
vikas shukla19-Aug-09 21:48
vikas shukla19-Aug-09 21:48 
AnswerRe: show/hide div Pin
Aman Bhullar19-Aug-09 22:19
Aman Bhullar19-Aug-09 22:19 
GeneralRe: show/hide div Pin
vikas shukla20-Aug-09 0:25
vikas shukla20-Aug-09 0:25 
AnswerRe: show/hide div Pin
kc_krishnan20-Aug-09 0:30
kc_krishnan20-Aug-09 0:30 
GeneralRe: show/hide div Pin
vikas shukla20-Aug-09 0:50
vikas shukla20-Aug-09 0:50 

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.