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

Verified file details

Filename: sample-large.sql
Exact size: 5,640,359 bytes
Displayed size: 5.38 MB
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.2 KB

1,000 rows

Download

Verified file details

Filename: sample-mysql.sql
Exact size: 56,547 bytes
Displayed size: 55.2 KB
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.4 KB

1,000 rows

Download

Verified file details

Filename: sample-postgresql.sql
Exact size: 56,771 bytes
Displayed size: 55.4 KB
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

Verified file details

Filename: sample-sqlite.sql
Exact size: 56,555 bytes
Displayed size: 55.2 KB
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

27.7 KB

500 rows

Download

Verified file details

Filename: sample-users-table.sql
Exact size: 28,413 bytes
Displayed size: 27.7 KB
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

Verified file details

Filename: sample-ecommerce.sql
Exact size: 251,375 bytes
Displayed size: 245 KB
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

Verified file details

Filename: sample-blog.sql
Exact size: 233,200 bytes
Displayed size: 228 KB
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.