session_find.go noCacheFind性能问题 #2042

New Issue

Mr1X · 2021-09-06T11:08:04Z

Mr1X commented

2021-09-06 11:08:04 +00:00

engine.Find()方法
调试发现

耗时函数
func (session *Session) noCacheFind(table *core.Table, containerValue reflect.Value, sqlStr string, args ...interface{}) error {}

for rows.Next() {} 耗时几秒以上

结果集4511条数据，大小 1.55MB

反射结果集的时候存在性能问题

engine.Find()方法调试发现耗时函数 func (session *Session) noCacheFind(table *core.Table, containerValue reflect.Value, sqlStr string, args ...interface{}) error {} for rows.Next() {} 耗时几秒以上结果集4511条数据，大小 1.55MB 反射结果集的时候存在性能问题

企业微信截图_20210906190451.png

57 KiB

cost.txt

451 KiB

lunny commented

2021-09-07 01:19:10 +00:00

How many records do you fetch? And please upgrade your xorm version.

lunny added the

need

feedback

label 2021-09-07 01:22:38 +00:00

Mr1X commented

2021-09-07 01:49:57 +00:00

How many records do you fetch? And please upgrade your xorm version.

table total record: 94476
select result record: 4511
result size: 1.5MB

I tried it yesterday on xorm.io/xorm v1.2.3
it also slow, and I checked that the key source code is the same

func (session *Session) noCacheFind

I'm sure there's a performance problem here for rows.Next() {}
Please see the logfile and search TODO and other Important logs like 111111, 222222, 33333

> How many records do you fetch? And please upgrade your xorm version. table total record: 94476 select result record: 4511 result size: 1.5MB I tried it yesterday on `xorm.io/xorm v1.2.3` it also slow, and I checked that the key source code is the same > func (session *Session) noCacheFind I'm sure there's a performance problem here `for rows.Next() {}` Please see the logfile and search `TODO` and other Important logs like `111111`, `222222`, `33333`

企业微信截图_20210907094730.png

41 KiB

cost-20210906_194308.910.txt

465 KiB