On 12/03/2015 05:31 AM, Stanislav Baiduzhyi wrote:
On Thu, Nov 26, 2015 at 5:36 PM, Anton Aylward
wrote: On 11/25/2015 04:27 AM, Vojtěch Zeisek wrote:
Any other ideas?
Add memory. Memory is cheaper. If necessary, upgrade the mobo so you can add more memory. That may still be cheaper.
Well that will help for reading, but due to ACID every transaction has to end up written on the drive, not even in kernel or fs cache (or whatever additional cache layer is involved). Which means that writing speed is still hard-bound by "random write" of your drive.
In absolute terms that is true, but in practical terms queries, joins and sorts dominate the activity of a database that is making use of its relational nature. If, perhaps, the database is dominated by writes, then really its doing logging, in which case a relational database is probably not the best choice for this function. As I keep saying ... Context is Everything Perhaps the OP would care to comment on the nature of the application that the database is being used for so that you and I don't end up doing a "yes-but" ping pong game any further. -- 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@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org