mysqljs/mysql

Read data as array

Open

#770 opened on Mar 24, 2014

View on GitHub
 (14 comments) (4 reactions) (0 assignees)JavaScript (2,502 forks)batch import
featurehelp wanted

Repository metrics

Stars
 (18,137 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

Is there option for getting records from mysql as flat array rather than object. Something like this { contractor_id: 199 , contractor_name: ... } represented as [199,"Andrew","Banks", 88.92, 55,15].

I want to speed up reading of 75k records, now it takes 35 seconds I am wandering is array representation would be transferred to node faster as 35 seconds.

Contributor guide

Research direction
Investigate how to add an option to return rows as arrays instead of objects in the mysqljs/mysql library. This involves modifying the query parsing logic to return arrays, and evaluating performance impact. Check existing discussions and pull requests for potential implementations.
Tech stack
javascriptnodejsmysql
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
JavaScriptNode.jsMySQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65