Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #62385

Re: Is it more CPU-efficient to read/write config file or read/write sqlite database?

Date 2013-12-19 18:56 +1100
From Cameron Simpson <cs@zip.com.au>
Subject Re: Is it more CPU-efficient to read/write config file or read/write sqlite database?
References <CAPTjJmrwvK3PQHvvBb2Nr06kDuqEhJ+yO99mX3k83V=vLqrrxA@mail.gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.4403.1387440986.18130.python-list@python.org> (permalink)

Show all headers | View raw


On 18Dec2013 21:50, Chris Angelico <rosuav@gmail.com> wrote:
> It's fundamentally about crash recovery, [...]
> Databases protect against that. If you want that protection, use a
> database. If you don't, use a file. There's nothing wrong with either
> option.

Look, broadly I agree. But this thread was about sharing access to
configs etc between processes. And it segued into suggesting sqlite.
Which is good and bad.

My point here is that here we were discussing cooperative access
to some shared state. And a "database" is tossed into the mix, with
its -- for this purpose --- overkill data integrity provisions.

So I feel obliged to point out the performance costs associated
with using a sledgehammer to bang in a tack.

Cheers,
-- 
Cameron Simpson <cs@zip.com.au>

Churchill's Commentary on Man: Man will occasionally stumble over the truth,
but most of the time he will pick himself up and continue on.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: Is it more CPU-efficient to read/write config file or read/write sqlite database? Cameron Simpson <cs@zip.com.au> - 2013-12-19 18:56 +1100

csiph-web