存储参数时,表格存在json结构,偶发存储时间过长,这种现象正常吗? 返回
使用这个存储 return await DbScoped.SugarScope.Insertable(entity).SplitTable().ExecuteReturnSnowflakeIdAsync();其中entity是类名如下:
public class ProductiveCollectsEntity
{
/// <summary>
/// 主键
/// </summary>
[SugarColumn(IsPrimaryKey = true, ColumnDescription = "主键")]
[JsonConverter(typeof(ValueToStringConverter))]
public long Id { get; set; }
/// <summary>
/// 生产过程记录ID
/// </summary>
[SugarColumn(ColumnDescription = "生产过程记录ID")]
public long FK_ProductiveProcessID { get; set; }
/// <summary>
/// 采集值
/// </summary>
[SugarColumn(IsJson = true, ColumnDataType = StaticConfig.CodeFirst_BigString, ColumnDescription = "工位参数集合")]
public List<NodeValue> CollectValues { get; set; }
}
/// <summary>
/// 数据列表
/// </summary>
public class NodeValue
{
/// <summary>
/// 主键ID
/// </summary>
public long Id { get; set; }
/// <summary>
/// 数据项
/// </summary>
public string Value { get; set; }
/// <summary>
/// 数据范围
/// </summary>
public NodeRange Range { get; set; }
}
/// <summary>
/// 数据范围
/// </summary>
public class NodeRange
{
/// <summary>
/// 上限值
/// </summary>
public decimal Upper { get; set; }
/// <summary>
/// 下限值
/// </summary>
public decimal Lower { get; set; }
}
2025-07-21 20:06:33.7892 INFO 用时:3.6212979 秒---------sql语句:INSERT INTO [Ts_ProductiveCollects20250701]
([FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[Id])
VALUES
('1947266933766656000','[{"Id":1844283810540425252,"Value":"","Range":null},{"Id":1844283810540425249,"Value":"","Range":null},{"Id":1844283810540425248,"Value":"","Range":null},{"Id":1844283810540425312,"Value":"","Range":null},{"Id":1844283810540425313,"Value":"","Range":null},{"Id":1844283810540425314,"Value":"","Range":null},{"Id":1844283810540425315,"Value":"","Range":null},{"Id":1844283810540425316,"Value":"","Range":null},{"Id":1844283810540425317,"Value":"","Range":null},{"Id":1844283810540425318,"Value":"","Range":null},{"Id":1844283810540425319,"Value":"","Range":null},{"Id":1844283810540425320,"Value":"","Range":null},{"Id":1844283810540425321,"Value":"","Range":null},{"Id":1844283810540425322,"Value":"","Range":null},{"Id":1844283810540425323,"Value":"","Range":null},{"Id":1844283810540425324,"Value":"","Range":null},{"Id":1844283810540425325,"Value":"","Range":null},{"Id":1844283810540425326,"Value":"","Range":null},{"Id":1844283810540425327,"Value":"","Range":null},{"Id":1844283810540425328,"Value":"","Range":null},{"Id":1844283810540425329,"Value":"","Range":null},{"Id":1844283810540425253,"Value":"-1","Range":null},{"Id":1844283810540425254,"Value":"-1","Range":null},{"Id":1844283810540425255,"Value":"-1","Range":null},{"Id":1844283810540425256,"Value":"-1","Range":null},{"Id":1844283810540425257,"Value":"-1","Range":null},{"Id":1844283810540425258,"Value":"-1","Range":null},{"Id":1844283810540425259,"Value":"-1","Range":null},{"Id":1844283810540425247,"Value":"-1","Range":null},{"Id":1844283810540425260,"Value":"-1","Range":null},{"Id":1844283810540425261,"Value":"-1","Range":null},{"Id":1844283810540425262,"Value":"-1","Range":null},{"Id":1844283810540425263,"Value":"-1","Range":null},{"Id":1844283810540425264,"Value":"-1","Range":null},{"Id":1844283810540425265,"Value":"-1","Range":null},{"Id":1844283810540425266,"Value":"-1","Range":null},{"Id":1844283810540425267,"Value":"-1","Range":null},{"Id":1844283810540425268,"Value":"-1","Range":null},{"Id":1844283810540425269,"Value":"-1","Range":null},{"Id":1844283810540425270,"Value":"-1","Range":null},{"Id":1844283810540425271,"Value":"-1","Range":null},{"Id":1844283810540425272,"Value":"-1","Range":null},{"Id":1844283810540425273,"Value":"867.887","Range":null},{"Id":1844283810540425274,"Value":"1000","Range":null},{"Id":1844283810540425275,"Value":"600","Range":null},{"Id":1844283810540425276,"Value":"-1","Range":null},{"Id":1844283810540425277,"Value":"-1","Range":null},{"Id":1844283810540425278,"Value":"-1","Range":null},{"Id":1844283810540425279,"Value":"844.265","Range":null},{"Id":1844283810540425280,"Value":"1000","Range":null},{"Id":1844283810540425281,"Value":"600","Range":null},{"Id":1844283810540425282,"Value":"0","Range":null},{"Id":1844283810540425283,"Value":"0","Range":null},{"Id":1844283810540425284,"Value":"0","Range":null},{"Id":1844283810540425285,"Value":"0","Range":null},{"Id":1844283810540425286,"Value":"0","Range":null},{"Id":1844283810540425287,"Value":"0","Range":null},{"Id":1844283810540425288,"Value":"0","Range":null},{"Id":1844283810540425289,"Value":"0","Range":null},{"Id":1844283810540425290,"Value":"0","Range":null},{"Id":1844283810540425291,"Value":"0","Range":null},{"Id":1844283810540425292,"Value":"0","Range":null},{"Id":1844283810540425293,"Value":"0","Range":null},{"Id":1844283810540425294,"Value":"0","Range":null},{"Id":1844283810540425295,"Value":"0","Range":null},{"Id":1844283810540425296,"Value":"0","Range":null},{"Id":1844283810540425297,"Value":"0","Range":null},{"Id":1844283810540425298,"Value":"0","Range":null},{"Id":1844283810540425299,"Value":"0","Range":null},{"Id":1844283810540425300,"Value":"0","Range":null},{"Id":1844283810540425301,"Value":"0","Range":null},{"Id":1844283810540425302,"Value":"0","Range":null},{"Id":1844283810540425303,"Value":"0","Range":null},{"Id":1844283810540425304,"Value":"0","Range":null},{"Id":1844283810540425305,"Value":"0","Range":null},{"Id":1844283810540425306,"Value":"0","Range":null},{"Id":1844283810540425307,"Value":"0","Range":null},{"Id":1844283810540425308,"Value":"0","Range":null},{"Id":1844283810540425309,"Value":"0","Range":null},{"Id":1844283810540425310,"Value":"0","Range":null},{"Id":1844283810540425311,"Value":"7.899995","Range":null}]',GETDATE(),'1731839851038380032',0,'1947266933892485120') ; <ExecuteCommandAsync>d__126.MoveNext => AdoProvider.ExecuteAfter => <>c__DisplayClass2_1.<AddSqlSugar>b__2
2025-07-21 20:06:33.7892 INFO 用时:3.8082131 秒---------sql语句:INSERT INTO [Ts_ProductiveCollects20250701]
([FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[Id])
VALUES
('1947266932395118592','[{"Id":1844273288399032450,"Value":"","Range":null},{"Id":1844273288399032447,"Value":"","Range":null},{"Id":1844273288399032446,"Value":"","Range":null},{"Id":1844273288399032510,"Value":"ODP2025000004.1","Range":null},{"Id":1844273288399032511,"Value":"ODP2025000050.1","Range":null},{"Id":1844273288399032512,"Value":"","Range":null},{"Id":1844273288399032513,"Value":"","Range":null},{"Id":1844273288399032514,"Value":"","Range":null},{"Id":1844273288399032515,"Value":"","Range":null},{"Id":1844273288399032516,"Value":"","Range":null},{"Id":1844273288399032517,"Value":"","Range":null},{"Id":1844273288399032518,"Value":"","Range":null},{"Id":1844273288399032519,"Value":"","Range":null},{"Id":1844273288399032520,"Value":"","Range":null},{"Id":1844273288399032521,"Value":"","Range":null},{"Id":1844273288399032522,"Value":"","Range":null},{"Id":1844273288399032523,"Value":"","Range":null},{"Id":1844273288399032524,"Value":"","Range":null},{"Id":1844273288399032525,"Value":"","Range":null},{"Id":1844273288399032526,"Value":"","Range":null},{"Id":1844273288399032527,"Value":"","Range":null},{"Id":1844273288399032451,"Value":"1","Range":null},{"Id":1844273288399032452,"Value":"1","Range":null},{"Id":1844273288399032453,"Value":"3","Range":null},{"Id":1844273288399032454,"Value":"3","Range":null},{"Id":1844273288399032455,"Value":"0","Range":null},{"Id":1844273288399032456,"Value":"0","Range":null},{"Id":1844273288399032457,"Value":"3","Range":null},{"Id":1844273288399032445,"Value":"3","Range":null},{"Id":1844273288399032458,"Value":"0","Range":null},{"Id":1844273288399032459,"Value":"0","Range":null},{"Id":1844273288399032460,"Value":"0","Range":null},{"Id":1844273288399032461,"Value":"0","Range":null},{"Id":1844273288399032462,"Value":"0","Range":null},{"Id":1844273288399032463,"Value":"0","Range":null},{"Id":1844273288399032464,"Value":"0","Range":null},{"Id":1844273288399032465,"Value":"0","Range":null},{"Id":1844273288399032466,"Value":"0","Range":null},{"Id":1844273288399032467,"Value":"0","Range":null},{"Id":1844273288399032468,"Value":"0","Range":null},{"Id":1844273288399032469,"Value":"0","Range":null},{"Id":1844273288399032470,"Value":"0","Range":null},{"Id":1844273288399032471,"Value":"0","Range":null},{"Id":1844273288399032472,"Value":"0","Range":null},{"Id":1844273288399032473,"Value":"0","Range":null},{"Id":1844273288399032474,"Value":"0","Range":null},{"Id":1844273288399032475,"Value":"0","Range":null},{"Id":1844273288399032476,"Value":"0","Range":null},{"Id":1844273288399032477,"Value":"0","Range":null},{"Id":1844273288399032478,"Value":"0","Range":null},{"Id":1844273288399032479,"Value":"0","Range":null},{"Id":1844273288399032480,"Value":"0","Range":null},{"Id":1844273288399032481,"Value":"0","Range":null},{"Id":1844273288399032482,"Value":"0","Range":null},{"Id":1844273288399032483,"Value":"0","Range":null},{"Id":1844273288399032484,"Value":"0","Range":null},{"Id":1844273288399032485,"Value":"0","Range":null},{"Id":1844273288399032486,"Value":"0","Range":null},{"Id":1844273288399032487,"Value":"0","Range":null},{"Id":1844273288399032488,"Value":"0","Range":null},{"Id":1844273288399032489,"Value":"0","Range":null},{"Id":1844273288399032490,"Value":"0","Range":null},{"Id":1844273288399032491,"Value":"0","Range":null},{"Id":1844273288399032492,"Value":"0","Range":null},{"Id":1844273288399032493,"Value":"0","Range":null},{"Id":1844273288399032494,"Value":"0","Range":null},{"Id":1844273288399032495,"Value":"0","Range":null},{"Id":1844273288399032496,"Value":"0","Range":null},{"Id":1844273288399032497,"Value":"0","Range":null},{"Id":1844273288399032498,"Value":"0","Range":null},{"Id":1844273288399032499,"Value":"0","Range":null},{"Id":1844273288399032500,"Value":"0","Range":null},{"Id":1844273288399032501,"Value":"0","Range":null},{"Id":1844273288399032502,"Value":"0","Range":null},{"Id":1844273288399032503,"Value":"0","Range":null},{"Id":1844273288399032504,"Value":"0","Range":null},{"Id":1844273288399032505,"Value":"0","Range":null},{"Id":1844273288399032506,"Value":"0","Range":null},{"Id":1844273288399032507,"Value":"0","Range":null},{"Id":1844273288399032508,"Value":"0","Range":null},{"Id":1844273288399032509,"Value":"8.799997","Range":null}]',GETDATE(),'1731839851038380032',0,'1947266933108150272') ; <ExecuteCommandAsync>d__126.MoveNext => AdoProvider.ExecuteAfter => <>c__DisplayClass2_1.<AddSqlSugar>b__2
2025-07-21 20:06:33.7892 INFO 用时:7.1891616 秒---------sql语句:INSERT INTO [Ts_ProductiveCollects20250701]
([FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[Id])
VALUES
('1947266917752803328','[{"Id":1844281259271131168,"Value":"","Range":null},{"Id":1844281259271131165,"Value":"","Range":null},{"Id":1844281259271131164,"Value":"","Range":null},{"Id":1844281259271131228,"Value":"","Range":null},{"Id":1844281259271131229,"Value":"","Range":null},{"Id":1844281259271131230,"Value":"","Range":null},{"Id":1844281259271131231,"Value":"","Range":null},{"Id":1844281259271131232,"Value":"","Range":null},{"Id":1844281259271131233,"Value":"","Range":null},{"Id":1844281259271131234,"Value":"","Range":null},{"Id":1844281259271131235,"Value":"","Range":null},{"Id":1844281259271131236,"Value":"","Range":null},{"Id":1844281259271131237,"Value":"","Range":null},{"Id":1844281259271131238,"Value":"","Range":null},{"Id":1844281259271131239,"Value":"","Range":null},{"Id":1844281259271131240,"Value":"","Range":null},{"Id":1844281259271131241,"Value":"","Range":null},{"Id":1844281259271131242,"Value":"","Range":null},{"Id":1844281259271131243,"Value":"","Range":null},{"Id":1844281259271131244,"Value":"","Range":null},{"Id":1844281259271131245,"Value":"","Range":null},{"Id":1844281259271131169,"Value":"1","Range":null},{"Id":1844281259271131170,"Value":"1","Range":null},{"Id":1844281259271131171,"Value":"0","Range":null},{"Id":1844281259271131172,"Value":"0","Range":null},{"Id":1844281259271131173,"Value":"0","Range":null},{"Id":1844281259271131174,"Value":"0","Range":null},{"Id":1844281259271131175,"Value":"0","Range":null},{"Id":1844281259271131163,"Value":"0","Range":null},{"Id":1844281259271131176,"Value":"0","Range":null},{"Id":1844281259271131177,"Value":"0","Range":null},{"Id":1844281259271131178,"Value":"0","Range":null},{"Id":1844281259271131179,"Value":"0","Range":null},{"Id":1844281259271131180,"Value":"0","Range":null},{"Id":1844281259271131181,"Value":"0","Range":null},{"Id":1844281259271131182,"Value":"0","Range":null},{"Id":1844281259271131183,"Value":"0","Range":null},{"Id":1844281259271131184,"Value":"0","Range":null},{"Id":1844281259271131185,"Value":"0","Range":null},{"Id":1844281259271131186,"Value":"0","Range":null},{"Id":1844281259271131187,"Value":"0","Range":null},{"Id":1844281259271131188,"Value":"0","Range":null},{"Id":1844281259271131189,"Value":"0","Range":null},{"Id":1844281259271131190,"Value":"0","Range":null},{"Id":1844281259271131191,"Value":"0","Range":null},{"Id":1844281259271131192,"Value":"0","Range":null},{"Id":1844281259271131193,"Value":"0","Range":null},{"Id":1844281259271131194,"Value":"0","Range":null},{"Id":1844281259271131195,"Value":"0","Range":null},{"Id":1844281259271131196,"Value":"0","Range":null},{"Id":1844281259271131197,"Value":"0","Range":null},{"Id":1844281259271131198,"Value":"0","Range":null},{"Id":1844281259271131199,"Value":"0","Range":null},{"Id":1844281259271131200,"Value":"0","Range":null},{"Id":1844281259271131201,"Value":"0","Range":null},{"Id":1844281259271131202,"Value":"0","Range":null},{"Id":1844281259271131203,"Value":"0","Range":null},{"Id":1844281259271131204,"Value":"0","Range":null},{"Id":1844281259271131205,"Value":"0","Range":null},{"Id":1844281259271131206,"Value":"0","Range":null},{"Id":1844281259271131207,"Value":"0","Range":null},{"Id":1844281259271131208,"Value":"0","Range":null},{"Id":1844281259271131209,"Value":"0","Range":null},{"Id":1844281259271131210,"Value":"0","Range":null},{"Id":1844281259271131211,"Value":"0","Range":null},{"Id":1844281259271131212,"Value":"0","Range":null},{"Id":1844281259271131213,"Value":"0","Range":null},{"Id":1844281259271131214,"Value":"0","Range":null},{"Id":1844281259271131215,"Value":"0","Range":null},{"Id":1844281259271131216,"Value":"0","Range":null},{"Id":1844281259271131217,"Value":"0","Range":null},{"Id":1844281259271131218,"Value":"0","Range":null},{"Id":1844281259271131219,"Value":"0","Range":null},{"Id":1844281259271131220,"Value":"0","Range":null},{"Id":1844281259271131221,"Value":"0","Range":null},{"Id":1844281259271131222,"Value":"0","Range":null},{"Id":1844281259271131223,"Value":"0","Range":null},{"Id":1844281259271131224,"Value":"0","Range":null},{"Id":1844281259271131225,"Value":"0","Range":null},{"Id":1844281259271131226,"Value":"0","Range":null},{"Id":1844281259271131227,"Value":"3.6999986","Range":null}]',GETDATE(),'1731839851038380032',0,'1947266918927208448') ; <ExecuteCommandAsync>d__126.MoveNext => AdoProvider.ExecuteAfter => <>c__DisplayClass2_1.<AddSqlSugar>b__2
热忱回答(1)
-
fate sta VIP0
2025/7/22如果有其他地方用事务可能会等待。
0 回复