1 million rows/second is the WORST to expect

preview_player
Показать описание
If your database isn't loading 1 million rows per second, then it is time to investigate, because something is definitely stopping any modern CPU from getting that level of performance.

Follow me!

The Podcast!

Subscribe for new tech videos every week

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

#sql #database
  1. SQL and Database explained!
  2. oracle
  3. oracle database
  4. asktom
  5. office hours
Рекомендации по теме
1 million rows/second 0:04:47

1 million rows/second is the WORST to expect

I Tried to 0:14:21

I Tried to Query 10 MILLION Rows in Postgres in 1 Second

ONE MILLION rows 1:08:12

ONE MILLION rows per second on a laptop!

SQL Server 2019 0:00:57

SQL Server 2019 querying 1 trillion rows in 100 seconds

I Tried to 0:22:44

I Tried to Query 10 MILLION Rows in MySQL in 3 Seconds

Import More than 0:02:50

Import More than 1 million rows data in Excel

Ingesting over a 0:41:52

Ingesting over a million rows per second on a single database instance by Javier Ramírez - JOTB23

1 Billion Rows 0:08:58

1 Billion Rows Challenge

How Fast can 0:16:31

How Fast can Python Parse 1 Billion Rows of Data?

10 Million Rows 0:10:57

10 Million Rows of data Analyzed using Excel's Data Model

Processing 1 Billion 0:43:39

Processing 1 Billion Rows Per Second

Javier Ramirez - 0:43:00

Javier Ramirez - Ingesting over 4 million rows a second on a single instance

I loaded 100,000,000 0:18:27

I loaded 100,000,000 rows into MySQL (fast)

Java, How Fast 0:42:16

Java, How Fast Can You Parse 1 Billion Rows of Weather Data? • Roy van Rijn • GOTO 2024

How to handle 0:10:20

How to handle more than million rows in Excel - Interview Question 02

YouTube Records That 0:01:00

YouTube Records That Will Never Be Broken

Update a Table 0:07:01

Update a Table with Millions of Rows in SQL (Fast)

Querying 100 Billion 0:09:07

Querying 100 Billion Rows using SQL, 7 TB in a single table

Pushing Java to 0:49:09

Pushing Java to the Limits: Processing a Billion Rows in under 2 Seconds by ROY VAN RIJN

3 EASY WAYS 0:07:35

3 EASY WAYS TO EXPORT 1 MILLION ROWS from Power BI into Excel // Beginners Guide to Power BI

10 Million Rows 0:03:08

10 Million Rows of Data Loaded into Excel ( **see updated version of this - link in description**)

The LONGEST World 0:08:05

The LONGEST World Records

A Trillion Rows 0:39:04

A Trillion Rows Per Second as a Foundation for Interactive Analytics | MemSQL

VBA Mastery for 0:01:25

VBA Mastery for Loading Millions of Records into Access in 1 Second

Комментарии
Автор

you are my amazing (guru means) teacher, love you for all these lessons, god bless you connor

JoniPriya
Автор

I like Connor's approach - but, as he said, the most important hint for testing is always "Just try it!" 🙂
Greetings from Good Old Germany/Hessen .

QueryTuner
Автор

I did the same test with 6, 148, 900 rows from dba_objects (110797 blocks) and it took 19 seconds. 🤔

ashumCR
Автор

APPEND is definitely fast, but if we run two thread in parallel then APPEND wont work. Anyways thanks for giving the benchmark :)

vikram