Data mapping to struct is slow when the number of database queries is large.

[marunrun]

What do you want to ask

如上图所示，我使用clickhouse ， 然后查询了大概8万条数据， 总共耗时6.4s， 其中sql执行花费2.2s ， 剩下的应该是数据映射到struct 所花费的时间，可以看到这个时间接近sql执行的两倍， 这个时间在数据量更大的时候，耗时只会更夸张。

请问这种情况该如何优化？

是否只能将数据映射成map， 然后自己再手动转化成具体的map？

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

What do you want to ask

As shown in the picture above, I used clickhouse and then queried about 80,000 pieces of data. It took a total of 6.4s, of which sql execution took 2.2s. The rest should be the time spent mapping the data to the struct. You can see this time Nearly twice as long as SQL execution. This time will only become more exaggerated when the amount of data is larger.

How can I optimize this situation?

Can I only map the data into a map, and then manually convert it into a specific map?

[wln32]

@marunrun 可以升级到2.7.0版本，这个版本使用gf gen dao时会把entity目录的所有结构体加上orm tag，加快匹配速度

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

@marunrun You can upgrade to version 2.7.0. When using gf gen dao, this version will add orm tag to all structures in the entity directory to speed up matching.