dotnetcore / dotnetcore/SmartSql

FOR 标签拼接效率低下问题

Open
#126 0 comments 1 reaction 1 assignee Claimed by @Ahoo-Wang View on GitHub
enhancement
Dominant language
C#
Stars
1.1k
Forks
229
PR merge metrics
No merged PRs in 30d

Description

## SmartSql version 4.1.29

## Database Mysql and 5.7

## Steps to reproduce

总写入数据条数:1000


( ?Id,
?SysUserId,
?UserWechatId,
?OriginalWechatId,
?CustomWechatId,
?NickName)

Repository:
[Statement(Id = "SaveBatch")]
int SaveBatch(IList list);
Service:
Console.WriteLine("开始时间:" + DateTime.Now);
UserWechatFriendsRepository.SaveBatch(insertFriends);
Console.WriteLine("结束时间:" + DateTime.Now);

## Expected result

打印:
开始时间:2019/12/19 20:46:38
结束时间:2019/12/19 20:49:21
3分钟时长

## Actual result

//手动拼接sql
string sql = CreateSql(insertFriends);
Console.WriteLine("执行开始时间:" + DateTime.Now);
UserWechatFriendsRepository.SqlMapper.Execute(new SmartSql.RequestContext
{
Scope = nameof(UserWechatFriends),
SqlId = "Insert",
RealSql = sql
});
Console.WriteLine("执行结束时间:" + DateTime.Now);

打印:
执行开始时间:2019/12/20 11:07:01
执行结束时间:2019/12/20 11:07:02
时长:1s

## Stack trace

总结:For标签的拼接效率极低,希望可以改进

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.