Wed, Feb 07, 2007 at 07:36:10PM +0200: DragonK wrote:
> On 2/7/07, Teg <[EMAIL PROTECTED]> wrote:
> >
> >Hello ohadp,
> >
> >Well, my experience is, particularly when it's users using it and not
> >a personal project, that corruption happens fairly frequently when you
> >use this pragma. That's
On 2/7/07, Ken <[EMAIL PROTECTED]> wrote:
Try without the pragma and wrap the inserts with a begin transaction and a
commit...
The performance will be almost as good as with the pragma, with the
added benefit of consistent data and no corruption in the event of a crash
or power failure.
I
Try without the pragma and wrap the inserts with a begin transaction and a
commit...
The performance will be almost as good as with the pragma, with the added
benefit of consistent data and no corruption in the event of a crash or power
failure.
DragonK <[EMAIL PROTECTED]> wrote:
On 2/7/07, Teg <[EMAIL PROTECTED]> wrote:
Hello ohadp,
Well, my experience is, particularly when it's users using it and not
a personal project, that corruption happens fairly frequently when you
use this pragma. That's why I don't use it any more in my production
code.
Transactions are far
Hello ohadp,
Well, my experience is, particularly when it's users using it and not
a personal project, that corruption happens fairly frequently when you
use this pragma. That's why I don't use it any more in my production
code.
Transactions are far safer and fast too.
C
Wednesday, February 7,
5 matches
Mail list logo