How fast you can export and import 1 million data

Sofyan Hadi Ahmad
3 min readJun 21, 2020

--

Setup New Serverless Project

Before we start you need to have Serverless on your machine. You can install a serverless standalone binary version, or with npm.

MacOS/Linux

Run this command in your terminal:

curl -o- -L https://slss.io/install | bash

Windows

Install with Chocolatey:

choco install serverless

Via npm

Note: If you don’t already have Node on your machine, you’ll need to install it first. We suggest using the latest LTS version of NodeJS.

Install the Serverless CLI:

npm install -g serverless

Initial setup

To create a new serverless project, run below command and follow the prompts

serverless

For more detail visit:
https://www.serverless.com/framework/docs/getting-started/

Database Design

Setup NestJS Project

Run the following command to install NestJS

npm i -g @nestjs/cli

To create a new NestJS project, run following command and follow the prompts

nest new your-project-name

More details visit: https://docs.nestjs.com

Clone the project

https://github.com/sofyan-ahmad/export-and-import-large-dataset

Testing Method

- max

Download Result

Downloading 1,000

Downloading 100,000

Downloading 1,000,000

Upload Result

Uploading 1,000

Uploading 100,000

Uploading 1,000,000

> Turns out it was an error

Let’s try to upload 500,000

Uploading 500,000

Uploading 250,000

Also error

Set Higher Heap Size 2048

Still Error

Conclusion

Limit memory size v8

https://stackoverflow.com/questions/38587346/max-old-space-size-set-to-4gb-actually-limits-to-2gb?answertab=votes#tab-top

--

--

Sofyan Hadi Ahmad
Sofyan Hadi Ahmad

Written by Sofyan Hadi Ahmad

Innovation | Opensource | Human | Charity

No responses yet