I am developing a system in VB 2008 with MySql data base. I have some stored procedures witch execute queries that insert a huge quantity of registers in tables and sometimes, during debbuging time out expired occurs.
I ask for help in the Experts Exchange site and they told me to run routines with trouble in background and changing the time of time out in the connection string.
I´ve tried all the solutions they gave, but the time out expired remains and the expert who gave me the solutions told me that my problem could be in the queries.
In the attached file I put the SQL code of one of the queries where I have problems and the create statements for de tables that are in the SQL code.
The bigger table is tabitensentradasaida witch has 500000 rows.
J Gonzaga ScriptSQL.txt ScriptSQL.txt