Mailinglist Archive: opensuse (911 mails)

< Previous Next >
Re: [opensuse] Best FS fo PostgreSQL/MariaDB
On 12/03/2015 11:03 AM, Vojtěch Zeisek wrote:
How you use
the logs will be of importance here. Using them for accounting/billing
seems wasteful when the function is better implemented n the application.

They are set to log into the database (not system), but usage of logs is
extensive, basically just for statistics.

Depending on how you cut the statistics having them in the database
might not always be a good move.

If this is a function that is to be displayed to the web users, then its
really a web function and so should be in the database, but if its an
'accounting' function, what sites get use, who does what, weekly
reports, them having it in the database puts a load on the database that
isn't needed.

Its back to the "Context is Everything" discussion. The use-case is
what matters.

That being said, you can over-optimise for one and only one use case.
Back when SSD was still expensive I saw a use-case that put the system
on the SSD for little benefit because the loading of binaries was a one
time occurrence and the real traffic was to the "to huge to fit on the
SSD as well as the system" database. Heck, just putting the index
files rather than the system on the SSD would have been better!

Now the SSDs are large and cheap enough that it doesn't matter any more :-)

Never the less, memory is faster :-)



--
A: Yes.
> Q: Are you sure?
>> A: Because it reverses the logical flow of conversation.
>>> Q: Why is top posting frowned upon?

--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >