Filesystem or database storage?

Moderator: crythias

Locked
BenceQS
Znuny newbie
Posts: 10
Joined: 08 Apr 2019, 13:13
Znuny Version: OTRS 4.0
Real Name: Bence Szabo

Filesystem or database storage?

Post by BenceQS »

Hi there!

Which one is faster for storing article data? Filesystem or MySQL? And what do you prefer, why?

Thanks :)
Top
wurzel
Znuny guru
Posts: 3272
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Filesystem or database storage?

Post by wurzel »

Hi,

https://doc.otrs.com/doc/manual/admin/6 ... rs-storage



in summary: depends on your database and DBA and also on your storage speed and your size of your setup.

Florian
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
Top
fcasal
Znuny wizard
Posts: 336
Joined: 21 Apr 2014, 16:14
Znuny Version: 6.0.18

Re: Filesystem or database storage?

Post by fcasal »

I prefer filesystem because when you perform an upgrade, like from otrs 5 to 6, the script that update the db takes a lot of time if db is large. Fortunately, otrs allows you to change between one system to another on the fly and very fast, at least when you change from database storage to filesystem in a running enviroment.

Kind regards.
Top
Locked

Return to “Help”