RE: SQL command timeout

2004-10-22 Thread Jay Blanchard
[snip] >Check your mysql system variables for timeout variables (SHOW >VARIABLES;) Thanks Jay. After I do this I see there are a number of timeout values, none which refer to a sql command timeout. Are you able to pinpont which value I need to manipulate? Also, if I increase this value, wha

RE: SQL command timeout

2004-10-22 Thread Rick Dwyer
Check your mysql system variables for timeout variables (SHOW VARIABLES;) Thanks Jay. After I do this I see there are a number of timeout values, none which refer to a sql command timeout. Are you able to pinpont which value I need to manipulate? Also, if I increase this value, what are the

RE: SQL command timeout

2004-10-22 Thread Jay Blanchard
[snip] I have a lasso page with various Inlines to execute, updates, searches, deletes and SQL commands to summarize data from a database with several tables that have grown large and the query to the database lasts for several minutes during this process. I have just started noticing that it i