[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Big XML files... (was Re: [Pan-users] Re: Better processing of very
From: |
Steven D'Aprano |
Subject: |
Re: Big XML files... (was Re: [Pan-users] Re: Better processing of very large groups?) |
Date: |
Sat, 4 Jul 2009 13:35:51 +1000 |
User-agent: |
KMail/1.9.9 |
On Sat, 4 Jul 2009 01:15:24 pm Steven D'Aprano wrote:
> On Sat, 4 Jul 2009 12:56:36 pm Ron Johnson wrote:
> > Also (and maybe because I'm a DBA), this problem just *screams* for
> > SQLite and a database in the "First Normal Form".
>
> Please no. SQLite has problems with NFS. It's not so much that SQLite
> won't work on NFS as that when (not if) something breaks, it's
> difficult to unbreak it.
Oops, forgot to include the link to the FAQ:
http://www.sqlite.org/faq.html#q5
"You should avoid putting SQLite database files on NFS if multiple
processes might try to access the file at the same time."
Or if one process might fall over (perhaps because the power goes out
and your desktop suddenly shutsdown) and you wish to start the process
again afterwards.
Since NFS is very common in the Linux universe, I vote No on SQLite for
this.
--
Steven D'Aprano
- Re: [Pan-users] Re: Better processing of very large groups?, (continued)
- Re: [Pan-users] Re: Better processing of very large groups?, Travis, 2009/07/02
- [Pan-users] Re: Better processing of very large groups?, Duncan, 2009/07/03
- Re: [Pan-users] Re: Better processing of very large groups?, Travis, 2009/07/03
- Re: [Pan-users] Re: Better processing of very large groups?, Ron Johnson, 2009/07/03
- [Pan-users] Re: Better processing of very large groups?, Duncan, 2009/07/03
- Re: [Pan-users] Re: Better processing of very large groups?, Ron Johnson, 2009/07/03
- [Pan-users] Re: Better processing of very large groups?, Duncan, 2009/07/03
- Re: [Pan-users] Re: Better processing of very large groups?, Brad Rogers, 2009/07/03
Big XML files... (was Re: [Pan-users] Re: Better processing of very large groups?), Ron Johnson, 2009/07/03
- Re: Big XML files... (was Re: [Pan-users] Re: Better processing of very large groups?), Steven D'Aprano, 2009/07/03
- Re: Big XML files... (was Re: [Pan-users] Re: Better processing of very large groups?),
Steven D'Aprano <=
- Re: Big XML files... (was Re: [Pan-users] Re: Better processing of very large groups?), Ron Johnson, 2009/07/03
- Re: Big XML files... (was Re: [Pan-users] Re: Better processing of very large groups?), Steven D'Aprano, 2009/07/04
- [Pan-users] Re: Big XML files... (was Re: Re: Better processing of very large groups?), Matej Cepl, 2009/07/04
- Re: [Pan-users] Re: Big XML files... (was Re: Re: Better processing of very large groups?), Ron Johnson, 2009/07/04
[Pan-users] If SQLite has NFS locking problems... (was Re: Big XML files... (was ...)), Ron Johnson, 2009/07/04
[Pan-users] Re: If SQLite has NFS locking problems... (was Re: Big XML files... (was ...)), Duncan, 2009/07/04
Re: [Pan-users] Re: If SQLite has NFS locking problems... (was Re: Big XML files... (was ...)), Ron Johnson, 2009/07/04
[Pan-users] Re: Big XML files... (was Re: Re: Better processing of very large groups?), Duncan, 2009/07/04
[Pan-users] Re: Big XML files... (was Re: Re: Better processing of very large groups?), Duncan, 2009/07/04
Re: [Pan-users] Re: Big XML files... (was Re: Re: Better processing of very large groups?), Ron Johnson, 2009/07/04