[CONJS-262] Binary resultset parsing performance improvement Created: 2023-06-28  Updated: 2023-09-08  Resolved: 2023-06-28

Status: Closed
Project: MariaDB Connector/node.js
Component/s: performance
Affects Version/s: None
Fix Version/s: 3.2.1

Type: Task Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 Description   

Performance parsing binary resultset is slow compared to text resultset.
This is due to node.js Buffer.subarray that is very slow (issue).

current performance selecting 1000 rows of int + varchar 32:

  • text : 3530 operations per second
  • binary : 2352 operations per second.

 Comments   
Comment by Diego Dupin [ 2023-06-28 ]

2352 operations per second is now 3101 operations per second with correction. This can still be improved when node.js (chromium issue) is corrected and released in node.js

Generated at Thu Feb 08 03:23:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.