Large SQL File — 100,000 Rows

Download a free 5MB SQL file with 100,000 rows across 10 tables. Stress test database import performance, bulk INSERT throughput, query optimization, and index effectiveness on realistic data volumes.

sample-large.sql

5.38 MB

100,000 rows

Download

File details and verification

Filename: sample-large.sql
Exact size: 5,639,156 bytes
Displayed size: 5.38 MB
Catalog status: Valid catalog fixture
SHA-256: 45c6186904da36f9279ddeae61ea672296e10ea699e4f5737ad74533c738b023
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 100,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-large.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Other SQL files

sample-mysql.sql

55.6 KB

1,000 rows

Download

File details and verification

Filename: sample-mysql.sql
Exact size: 56,910 bytes
Displayed size: 55.6 KB
Catalog status: Valid catalog fixture
SHA-256: 3feac5727e2d7f9a7fbaf226f293db7fc0c0c2d7961974d4869d9316603edccd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-mysql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-postgresql.sql

55.3 KB

1,000 rows

Download

File details and verification

Filename: sample-postgresql.sql
Exact size: 56,651 bytes
Displayed size: 55.3 KB
Catalog status: Valid catalog fixture
SHA-256: 9bd034cdb1452aefe78a9b94bdb353161ef4bd9abf183adedcddd612ac545cee
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-postgresql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-sqlite.sql

55.2 KB

1,000 rows

Download

File details and verification

Filename: sample-sqlite.sql
Exact size: 56,490 bytes
Displayed size: 55.2 KB
Catalog status: Valid catalog fixture
SHA-256: 15f0df10b8d315589cf5ebe044621c6a96e52ff3ae8b43e41063ca7515f326ad
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-sqlite.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-users-table.sql

28.1 KB

500 rows

Download

File details and verification

Filename: sample-users-table.sql
Exact size: 28,735 bytes
Displayed size: 28.1 KB
Catalog status: Valid catalog fixture
SHA-256: aad074e827941c55db90b7c118b96a544f3a84518cb2a7ab075a3b66bfbdb386
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 500
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-users-table.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-ecommerce.sql

245 KB

5,000 rows

Download

File details and verification

Filename: sample-ecommerce.sql
Exact size: 250,844 bytes
Displayed size: 245 KB
Catalog status: Valid catalog fixture
SHA-256: b6f6e4b4711ad979f21fa4ef0e3e7f4603c22f44156114e4373c27425b25eebd
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 5,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-ecommerce.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-blog.sql

228 KB

2,000 rows

Download

File details and verification

Filename: sample-blog.sql
Exact size: 233,739 bytes
Displayed size: 228 KB
Catalog status: Valid catalog fixture
SHA-256: 219a3fa539ba2c1d78b9bbd21605b8c863ac9b23cae396354387d0b1a5c2f12b
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/sql
Rows: 2,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-blog.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Frequently Asked Questions

How long does importing 100K rows take?

MySQL: 5–15 seconds with default settings. PostgreSQL: 3–10 seconds. Using COPY or LOAD DATA INFILE is 5–10x faster than individual INSERTs. Disable indexes during import for best performance.

Is 100K rows enough for performance testing?

100K rows is the threshold where poor queries become noticeably slow. Missing indexes on JOINed columns will show 10–100x slowdowns. It's the minimum for meaningful EXPLAIN ANALYZE testing.

How do I optimize imports for large SQL files?

Disable autocommit, wrap INSERTs in transactions, disable foreign key checks during import, and drop/recreate indexes after data loading. MySQL: SET FOREIGN_KEY_CHECKS=0. PostgreSQL: SET session_replication_role=replica.

Other data formats

JSON XML CSV Excel (XLSX)

Similar files in other formats

sample-simple.json

87 B

1 rows

Download

File details and verification

Filename: sample-simple.json
Exact size: 87 bytes
Displayed size: 87 B
Catalog status: Valid catalog fixture
SHA-256: 2ed7134796dcc9670f375f725f09c73fd518f6d2e463dd31081137a4bd068235
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/json
Rows: 1
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/json/sample-simple.json

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-simple.xml

153 B

Download

File details and verification

Filename: sample-simple.xml
Exact size: 153 bytes
Displayed size: 153 B
Catalog status: Valid catalog fixture
SHA-256: c329bdea7bc82f57371d383f658c7dde4ecf4cac01c8be1662271ff075c9f4c2
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/xml
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/xml/sample-simple.xml

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1kb.yaml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.yaml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 2e383ce376f7cdea9bc326b12d679a226657fff5a9e1f99cda389caa956f5863
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/yaml/sample-1kb.yaml

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-1kb.toml

1 KB

30 lines

Download

File details and verification

Filename: sample-1kb.toml
Exact size: 1,024 bytes
Displayed size: 1 KB
Catalog status: Valid catalog fixture
SHA-256: 5321484b28dd4dd11e150116a8e70e97e8d5d953bb38a6340a13766822d35faf
Header signature: Not applicable (no stable header signature for this format)
Verified on: 2026-08-10
MIME type: application/octet-stream
Lines: 30
Note: simple-config
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/toml/sample-1kb.toml

See how TrueFileSize generates and measures sample files, or review the editorial policy.