PHP Pear:PHPExcel vs PHP:PHP-Excel-Reader vs Coldfusion:CFspreadsheet vs Railo:CFSpreadsheet.
PHP Pear:PHPExcel与PHP:PHP-Excel-Reader vs Coldfusion:CFspreadsheet vs Railo:CFSpreadsheet。
Has anyone done any comparison performance or load tests for large/frequent data-set imports to databases? If so, what do the performance comparisons look like? I'm hoping someone already has specific time/resource metrics.
有没有人对大型/频繁数据集导入数据库进行过任何比较性能或负载测试?如果是这样,性能比较是什么样的?我希望有人已经有特定的时间/资源指标。
Also open to any possible alternative spreadsheet processing libraries that can serve up web content. Java/C-derivatives are welcome.
也可以使用任何可以提供Web内容的替代电子表格处理库。欢迎使用Java / C衍生产品。
1 个解决方案
#1
2
I faced the same problem few times ago and it appeared that PHP libraries to deal with XLS were relatively slow. (Didn't try all the one you mentioned here though) We used PHPExcel for our main try and it was really not satisfying.
我几次遇到同样的问题,似乎处理XLS的PHP库相对较慢。 (没有尝试过你在这里提到的所有内容)我们使用PHPExcel作为我们的主要尝试,它真的不满意。
Our solution was to use Java' library OpenXLS and create a PHP <> Java interface. Not sure if you'd need it in your case or if you can import from Java directly.
我们的解决方案是使用Java的库OpenXLS并创建一个PHP <> Java接口。不确定您是否需要它,或者您是否可以直接从Java导入。
Anyway, the main problem about these libraries was always the same : lack of documentation.
无论如何,这些库的主要问题始终是相同的:缺乏文档。
#1
2
I faced the same problem few times ago and it appeared that PHP libraries to deal with XLS were relatively slow. (Didn't try all the one you mentioned here though) We used PHPExcel for our main try and it was really not satisfying.
我几次遇到同样的问题,似乎处理XLS的PHP库相对较慢。 (没有尝试过你在这里提到的所有内容)我们使用PHPExcel作为我们的主要尝试,它真的不满意。
Our solution was to use Java' library OpenXLS and create a PHP <> Java interface. Not sure if you'd need it in your case or if you can import from Java directly.
我们的解决方案是使用Java的库OpenXLS并创建一个PHP <> Java接口。不确定您是否需要它,或者您是否可以直接从Java导入。
Anyway, the main problem about these libraries was always the same : lack of documentation.
无论如何,这些库的主要问题始终是相同的:缺乏文档。