IronXL里程碑:效能與記憶體大幅提升

This article was translated from English: Does it need improvement?
Translated
View the article in English

*更新*: IronXL效能改進 主要優勢:提高營運速度,實現新的效率。 次要好處:記憶體分配得到改善。 出貨日期**:2023年9月

截至我們最新的 2023 年 9 月版本 (2023.9.29) 發佈時, IronXL 的NuGet安裝量已超過 50 萬次,我們回顧了我們的開發團隊在過去一年中取得的所有成就和更新,使IronXL成為.NET Excel 文件庫市場的領先產品。

"我需要更快的IronXL,即使在我的低配置電腦上也是如此!"

IronXL性能提升

IronXL在運行速度和內存方面都取得了巨大的進步。 在本節中,我們將把IronXL與一年前,即去年 9 月(2022.9)以及上個月 8 月(2023.8)進行比較。

IronXL 2023.9 版本(最新版)比較IronXL 2023.8 版本(上個月版)比較IronXL 2022.9 版本(去年版)

圖 0

從下圖可以看出,許多指標都在進行比較:根據所有指標, IronXL與去年同期相比均有所改善。

競爭對手比較IronXL 2023.9 版本

圖 1 圖 2 圖 3 圖 4

IronXL記憶體分配改進

IronXL在運行記憶體使用方面取得了巨大的進步。 這是一個重要的進步,它確保新版本的IronXL將使用更少的內存,從而在不更改程式碼的情況下節省生產時間和金錢。

在本節中,我們將把IronXL與一年前,即去年 9 月(2022.9)以及上個月 8 月(2023.8)進行比較。

圖 5

下圖比較了三個指標:

存取單元格區域的屬性

同樣的操作,記憶體使用量從 4.41 千位元組減少到 3.8 千字節,比前一年提高了 14%!

隨機單元格操作

同樣的操作,記憶體使用量從 9.26 千位元組減少到約 8.5 千字節,比前一年提高了 8%!

刪除大行操作

同樣的操作,記憶體使用量從 65.46 千位元組減少到約 20.3 千字節,比前一年提高了 69%! 請注意 Y 軸上的對數刻度,因為這低估了我們將這項操作減少了三分之二的事實。

使用常規的 Y 軸,我們可以看到這 69% 的改進:

圖 6

下面我們也將比較規模更大的業務:

圖 7

下圖比較了三個指標:

資料單元操作

同樣的操作,記憶體使用量從 676.81 千位元組減少到 669.91 千字節,比前一年提高了 2%! 考慮到每次編輯 Excel 文件時都會出現許多這樣的情況,這確實意義重大。

儲存大文件

同樣的操作,記憶體使用量從約 1028 兆位元組減少到約 838 兆位元組,與去年同期和去年同期相比,記憶體使用量均提高了 18%!


IronXL里程碑:性能提升

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 12
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Productupdates.php
Line: 19
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/ready_to_started_202509.php
Line: 19
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 489
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Productupdates.php
Line: 19
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

準備好開始了嗎?
Nuget 下載 1,890,100 | 版本: 2026.3 剛剛發布

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 17
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/sections/three_column_docs_page_structure.php
Line: 71
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/views/products/product-updates/index.php
Line: 2
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 552
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Productupdates.php
Line: 19
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

A PHP Error was encountered

Severity: Notice

Message: Undefined index: IronXl.Excel

Filename: helpers/counter_helper.php

Line Number: 85

Backtrace:

File: /var/www/ironpdf.com/application/helpers/counter_helper.php
Line: 85
Function: _error_handler

File: /var/www/ironpdf.com/application/views/main/sections/still_scrolling_202512.php
Line: 24
Function: getTotalDonwloadNumber

File: /var/www/ironpdf.com/application/views/products/sections/three_column_docs_page_structure.php
Line: 71
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/views/products/product-updates/index.php
Line: 2
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 88
Function: view

File: /var/www/ironpdf.com/application/libraries/Render.php
Line: 552
Function: view

File: /var/www/ironpdf.com/application/controllers/Products/Productupdates.php
Line: 19
Function: render_products_view

File: /var/www/ironpdf.com/index.php
Line: 292
Function: require_once

Still Scrolling Icon

還在捲動嗎?

想要快速證明? PM > Install-Package IronXl.Excel
執行範例 觀看您的資料變成試算表。