timeout

 为什么插入下面这条sql语句会timeout？前提是数据库字段都能够满足长度的需求。Insert Into [Order] ( [client_party_order_id],[client_order_id],[created_at],[billing_address_id],[shipping_address_id],[order_type],[miscellaneous_data],[packslip_message],[reference_num],[rep_info_id],[create_on],[status_code],[request_counter],[error_message],[zoyto_order_id],[zoyto_status_code],[program_id],[updated_on],[ready_to_transfer],[locked],[transferred_on],[has_updates],[expected_ship_date] ) values ( 132998,132998,N'2010-12-10T15:38:45Z',639609,639609,N'PARTY_ORDER',null,N'                                                                                                                                                                                                                                                ',N'132998',6303,'2010-12-12 22:53:12',N'ACCEPTED',11436,null,0,null,354,null,0,0,null,0,'2010-12-13 00:00:00' );SELECT @@IDENTITY 

解决方案 »

  1.   


     Insert Into [Order] ( [client_party_order_id],[client_order_id],[created_at],[billing_address_id],[shipping_address_id],[order_type],[miscellaneous_data],[packslip_message],[reference_num],[rep_info_id],[create_on],[status_code],[request_counter],[error_message],[zoyto_order_id],[zoyto_status_code],[program_id],[updated_on],[ready_to_transfer],[locked],[transferred_on],[has_updates],[expected_ship_date] ) values ( 132998,132998,N'2010-12-10T15:38:45Z',639609,639609,N'PARTY_ORDER',null,N'                                                                                                                                                                                                                                                ',N'132998',6303,'2010-12-12 22:53:12',N'ACCEPTED',11436,null,0,null,354,null,0,0,null,0,'2010-12-13 00:00:00' );SELECT @@IDENTITY 
      

  2.   

    也跟了，在本地跟的，没有问题，放到服务器上就有问题，遇到这种字符长的比如pickslip_messge,就timeout.一天至少发三封timeOut的邮件。亟待结局。我在app_log_table里面找了，全都是这类的sql query.