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
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://truefilesize.com/files/sql/sample-large.sql
Other SQL files
sample-mysql.sql
55.2 KB
1,000 rows
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://truefilesize.com/files/sql/sample-mysql.sql
sample-postgresql.sql
55.4 KB
1,000 rows
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://truefilesize.com/files/sql/sample-postgresql.sql
sample-sqlite.sql
55.2 KB
1,000 rows
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://truefilesize.com/files/sql/sample-sqlite.sql
sample-users-table.sql
27.7 KB
500 rows
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://truefilesize.com/files/sql/sample-users-table.sql
sample-ecommerce.sql
245 KB
5,000 rows
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://truefilesize.com/files/sql/sample-ecommerce.sql
sample-blog.sql
228 KB
2,000 rows
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://truefilesize.com/files/sql/sample-blog.sql
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
Similar files in other formats
sample-simple.json
87 B
1 rows
Verified file details
- Filename
- sample-simple.json
- Exact size
- 87 bytes
- Displayed size
- 87 B
- MIME type
- application/json
- Rows
- 1
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/json/sample-simple.json
sample-simple.xml
153 B
Verified file details
- Filename
- sample-simple.xml
- Exact size
- 153 bytes
- Displayed size
- 153 B
- MIME type
- application/xml
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/xml/sample-simple.xml
sample-1kb.yaml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.yaml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/yaml/sample-1kb.yaml
sample-1kb.toml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.toml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/toml/sample-1kb.toml