Which one is faster for storing article data? Filesystem or MySQL? And what do you prefer, why?
Thanks
Filesystem or database storage?
Moderator: crythias
-
BenceQS
- Znuny newbie
- Posts: 10
- Joined: 08 Apr 2019, 13:13
- Znuny Version: OTRS 4.0
- Real Name: Bence Szabo
Filesystem or database storage?
Hi there!
Which one is faster for storing article data? Filesystem or MySQL? And what do you prefer, why?
Thanks
Which one is faster for storing article data? Filesystem or MySQL? And what do you prefer, why?
Thanks
Re: Filesystem or database storage?
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
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 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- 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.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- 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.
Re: Filesystem or database storage?
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.
Kind regards.