Timeout expired after calling stocked procedure : I keep getting this error after the calling the stored procedure on mysql database :
"MySql.Data.MySqlClient.MySqlException (0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation"
I know that the problem is related to the query it takes to long to execute so my question is this query it is good ? is there another way to improve this stocked procedure : 


    CREATE DEFINER=`mysql`@`%` PROCEDURE `UpadtePriceToCalibre`(IN Dos int(6),    IN Var varchar(50), IN PRIX double(10,4) , IN Cal int(6))
    BEGIN
      insert into xxpch 
    select `NuméroDossier`,`NuméroLot`,`Variété`,`Client`,`NF`,`Calibre`,`PrixKg`,PRIX,`NetFacture`,(PRIX * PoidNet),NOW()         
    from detaildossier
    where NuméroDossier = Dos AND Variété LIKE CONCAT('%',Var,'%') AND Calibre= Cal;
    update detaildossier
    SET PrixKg = PRIX 
    	, NetFacture = (PRIX * PoidNet) 
        , PrixColis = (( PoidNet / NombreColis) * PRIX)
    WHERE NuméroDossier = Dos AND Variété LIKE CONCAT('%',Var,'%') AND Calibre= Cal;
    update aff_e ,cpv_d
    set aff_e.netcpv =(select sum(cpv_d.prxtot) from cpv_d where cpv_d.numdos = Dos AND cpv_d.numlot = aff_e.numlot)
    	,aff_e.mntvnt =(select sum(cpv_d.prxtot) from cpv_d where cpv_d.numdos = Dos AND cpv_d.numlot = aff_e.numlot)
    where  aff_e.numdos = Dos	AND cpv_d.numlot = aff_e.numlot;
    END

