Click here to Skip to main content
15,885,981 members
Home / Discussions / Web Development
   

Web Development

 
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 
GeneralRe: show/hide div Pin
kc_krishnan20-Aug-09 1:01
kc_krishnan20-Aug-09 1:01 
AnswerRe: show/hide div Pin
Marc Firth20-Aug-09 2:51
Marc Firth20-Aug-09 2:51 
Questionasp/html/javascript Pin
rajiv_kadam19-Aug-09 21:05
rajiv_kadam19-Aug-09 21:05 
AnswerRe: asp/html/javascript Pin
Aman Bhullar19-Aug-09 22:21
Aman Bhullar19-Aug-09 22:21 
QuestionWebpage data entry without Navigating to the page Pin
kc_krishnan19-Aug-09 18:49
kc_krishnan19-Aug-09 18:49 
GeneralSimple SEO for one page site Pin
Brady Kelly19-Aug-09 7:37
Brady Kelly19-Aug-09 7:37 

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.