I want to measure how long it takes to sync my site, gabo.es. I need to know the size of the site.
I open gabo.es in an empty app without an account:
Documents without media: 174 documents
Documents + Profiles
Documents + Profiles + Media
Documents + Comments
Documents + Comments + Backlinks (It is not possible rn)
All the Database
The DB size part worked from ls:
db.sqlite: 3.5G
db.sqlite-wal: 162.9M
total on disk ≈ 3.66GSQLM pragma_page_count(), pragma_page_size(); 1048576.0) AS sqlite_db_size, 0) AS missing_blobs
label docs blobs logical_size stored_sqlite_blob_size missing_blobs
------------------------- ---- ----- ------------ ----------------------- -------------
1 docs without media 194 1859 5.09 MiB 1.91 MiB 0
2 docs + profiles 194 1894 5.10 MiB 1.92 MiB 0
3 docs + profiles + media 194 3362 152.54 MiB 145.72 MiB 22
4 docs + comments 194 2353 5.30 MiB 2.11 MiB 0
label sqlite_db_sizeHow much time should it take to open gabo.es from my coworking.
gabo.es content size is about 153 MiB including media.
With your connection:
Download: 441 Mbps ≈ 52.6 MiB/s
Server/upload cap shown: 321 Mbps ≈ 38.3 MiB/s
Physical minimum download time: ~3–4 seconds
Actual Seed sync can be slower because it fetches 3,362 blobs, verifies them, decompresses data, and writes to SQLite.
Without media:
Docs only: 5.09 MiB logical, 1.91 MiB stored
Docs + profiles: 5.10 MiB logical, 1.92 MiB stored
Docs + comments: 5.30 MiB logical, 2.11 MiB stored
At your speed, physical minimum is well under 1 second.
We should be able download gabo.es with media under 4 secs, without media under 1 second.
Do you like what you are reading? Subscribe to receive updates.
Unsubscribe anytime