📝 Get my free SQL Cheat Sheets: www.databasest...
🎓 Learn and become confident in SQL: databasestar.m...
Have you ever wondered how to import one billion rows into an SQL database? Or how long it would take?
In this video, you'll see how to generate a file with 1 billion rows, how to import it into four different SQL databases, and how long it takes in each database.
⏱ TIMESTAMPS:
00:00 - The challenge
00:31 - Setting up the data
02:08 - MySQL
04:08 - Postgres
05:31 - SQL Server
07:35 - Oracle method 1
09:33 - Oracle method 2
🔗 VIDEO LINKS:
Gunnar Morling's blog post: www.morling.de...
1BRC GitHub repo: github.com/gun...
SQL scripts used in this video: github.com/bbr...
Commands to clone the repo and generate the file:
git clone github.com/gun...
java -version
mvnw verify
sh create_measurements.sh 1000000000
Specs of the computer used in this video:
Lenovo Ideapad 5 laptop
CPU: Intel i5 2.4 GHz
RAM: 16 GB
OS: Windows 11
Негізгі бет Ғылым және технология How To Load One BILLION Rows into an SQL Database
Пікірлер: 108