English 中文(简体)
Spreadsheet_Excel_Reader public api vs direct access rate differences (PHP)
原标题:Spreadsheet_Excel_Reader public api vs direct access speed difference (PHP)
  • 时间:2011-11-23 15:45:25
  •  标签:
  • php
  • excel

下面两处都有nes,头一只需要178秒才能穿透镜,而第二套需要1.25秒。 在内部,他们都在做同样的事。

$data->sheets[0][ cells ][$i][$j+1];

v

$data->val($i, $j+1);

阀值功能(除其他检查外):

return $this->sheets[$sheet][ cells ][$row][$col];

造成这种差异的原因何在?

最佳回答

要求使用的方法确实比财产更容易,但我想这会造成这种巨大差异。 我愿建议以Xdebug等内容对这两个案件进行定性分析,以了解瓶颈在哪里:

问题回答

暂无回答




相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签