views:

10

answers:

0

i have this procedure statement

<procedure id="InsertIOs" parameterMap="InsertIOsParams">
      SP_InsertIOs
    </procedure>

 </statements>

  <parameterMaps>
    <parameterMap id="InsertIOsParams">
      <parameter property="iosxml" column="iosxml" dbType="VarChar"/>
    </parameterMap>   
  </parameterMaps>

The name of the stored procedure is SP_InsertIOs which is expecting a string called "iosxml" which is passed in a hashtable(the key name is also iosxml). I use it to insert 10000 entities in the database and it works fine. If i use it to insert 50000 entities i get a timeout SqlException. How can i set a timeout for the procedure? I tried procedure id="InsertIOs" timeout="200" but with no result