[GH-ISSUE #21] Data fragmentation and database #9

New issue

Closed

opened 2026-03-02 16:46:58 +03:00 by kerem · 3 comments

kerem commented

2026-03-02 16:46:58 +03:00

Owner

Originally created by @KITblue on GitHub (Sep 19, 2020).
Original GitHub issue: https://github.com/photoprism/photoprism-docs/issues/21

Originally assigned to: @lastzero on GitHub.

The number of images generated by the program is too large, fragmentation is serious, and it has a great impact on the hard disk. Do you want to consider using a database

Originally created by @KITblue on GitHub (Sep 19, 2020). Original GitHub issue: https://github.com/photoprism/photoprism-docs/issues/21 Originally assigned to: @lastzero on GitHub. The number of images generated by the program is too large, fragmentation is serious, and it has a great impact on the hard disk. Do you want to consider using a database

kerem

2026-03-02 16:46:58 +03:00

closed this issue
added the
question
label

kerem commented

2026-03-02 16:46:59 +03:00

Author

Owner

@lastzero commented on GitHub (Sep 19, 2020):

Haven't heard the word fragmentation for a very long time. What file system?

You typically wouldn't store files in a database. And if you do, the database might as well store them as individual files or suffer from fragmentation if stored in a single binary.

@lastzero commented on GitHub (Sep 19, 2020): Haven't heard the word fragmentation for a very long time. What file system? You typically wouldn't store files in a database. And if you do, the database might as well store them as individual files or suffer from fragmentation if stored in a single binary.

kerem commented

2026-03-02 16:47:00 +03:00

Author

Owner

@lastzero commented on GitHub (Sep 20, 2020):

This question on Stackexchange seems related:

https://unix.stackexchange.com/questions/28756/what-is-the-most-high-performance-linux-filesystem-for-storing-a-lot-of-small-fi

TL;DR: Performance and fragmentation depend a lot on the specific file system

Money quote:

The only way to prevent file systems from distributing files over the drive, is to keep the partition only as big as you really need it, but pay attention not to make the partition too small, to prevent intrafile-fragmenting.

@lastzero commented on GitHub (Sep 20, 2020): This question on Stackexchange seems related: https://unix.stackexchange.com/questions/28756/what-is-the-most-high-performance-linux-filesystem-for-storing-a-lot-of-small-fi **TL;DR: Performance and fragmentation depend a lot on the specific file system** Money quote: > The only way to prevent file systems from distributing files over the drive, is to keep the partition only as big as you really need it, but pay attention not to make the partition too small, to prevent intrafile-fragmenting.

kerem commented

2026-03-02 16:47:00 +03:00

Author

Owner

@lastzero commented on GitHub (Sep 20, 2020):

I'll close this, since the repo is for our docs only.

If you have a specific feature request or bug report, you're welcome to open an issue in our main repo:

https://github.com/photoprism/photoprism/issues

@lastzero commented on GitHub (Sep 20, 2020): I'll close this, since the repo is for our docs only. If you have a specific feature request or bug report, you're welcome to open an issue in our main repo: https://github.com/photoprism/photoprism/issues

kerem referenced this issue

2026-03-02 16:47:25 +03:00

[PR #9] [MERGED] feat(setup): added fedora setup/build instructions #42