Edwin Eyan Moragas uttered:
On 8/6/07, Christian Smith <[EMAIL PROTECTED]> wrote:
<snip>
2) anybody ever implemented something like a single
process of sqlite doing queries for a lot of networked
clients?
A few people have implemented such a solution. It loses one of the
benefits of SQLite, however, in that SQLite is no longer admin free.
how so?
Because now you need to manage port numbers, multiple processes on
potentially multiple machines. Not massive overhead, but still not as easy
as starting or stopping your one process.
3) how big has your sqlite database grown? have you had any trouble
managing the db? any bad experiences as to stability of
the db file?
Stability of the file? In what sense? Compatibility? Or resistence to
corruption? Or size, perhaps?
resistance to corruption in particular. thinking about it, this
may be an OS issue but given that the OS is ok, how
does sqlite handle it?
SQLite uses a rollback journal along with timely OS level syncs to ensure
the database is always in a consistant or recoverable state. SQLite can
survive OS or hardware failure so long as the filesystem remains intact.
thank you for the response.
./e
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
