ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.

https://github.com/unvell/ReoGrid/issues

#1 2016-07-12 03:02:28

Wang Fan
Member
Registered: 2016-05-31
Posts: 6

数据量很大的话,怎么写入速度快呢

集合数据十几万条,怎么写入呢,可以多个线程一起写吗

Offline

#2 2016-07-13 01:14:57

oops
Moderator
Registered: 2015-11-03
Posts: 54

Re: 数据量很大的话,怎么写入速度快呢

现在的方法有性能问题么?比如现在用多少时间?

Offline

#3 2016-07-13 05:35:35

Wang Fan
Member
Registered: 2016-05-31
Posts: 6

Re: 数据量很大的话,怎么写入速度快呢

现在是双重循环 ,一个一个单元格赋值啊,1万条数据都要几分钟

Offline

#4 2016-07-13 23:08:05

oops
Moderator
Registered: 2015-11-03
Posts: 54

Re: 数据量很大的话,怎么写入速度快呢

单纯写入数据,我们测试 10000行x10列 = 100000个单元格,只需要500毫秒左右

需要几分钟的话可能跟取得数据部分有关系,你的数据是从哪里取得的?

Offline

#5 2016-07-20 07:22:19

Wang Fan
Member
Registered: 2016-05-31
Posts: 6

Re: 数据量很大的话,怎么写入速度快呢

可以利用反射吗,或者有没有一行行赋值的方法,一个个不现实

Offline

#6 2016-08-05 12:26:52

oops
Moderator
Registered: 2015-11-03
Posts: 54

Re: 数据量很大的话,怎么写入速度快呢

底层是为一个个优化的,一行行赋值可能提高性能,但也就是几十毫秒的程度,主要查清楚现在的性能瓶颈在哪里。

Offline

Board footer

Powered by FluxBB