cubicweb #577952 avoid fsyncing with sqlite [rejected]

when running tests, syncing slows down everything (and on a shared machine everyone pays)

there's a http://www.sqlite.org/pragma.html#pragma_synchronous to use

prioritynormal
typeenhancement
done in<not specified>
load0.000
load left0.000
closed by<not specified>

Workflow history

from state (1)to statecommentdateUser
openrejected2009/12/22 20:21 UTCsthenault

Comments

  • 2009/12/03 18:50, written by acampeas

    hmm I've tried to set a cursor.execute('pragma synchronous = OFF') line in native.py to see what we get (still not sure it's the right place to set it) and things went incredibly slower ...

  • 2009/12/18 08:19, written by acampeas

    in all fairness, what bothered me most was the slowness of blob retrieval (which is not supposed to involve syncs at all)

  • 2009/12/22 20:21, written by sthenault

    I've done several test with different options without much success (hence I didn't commit anything). Rejecting for now.

add comment

Ticket #577952 - latest update on 2009/12/22, created on 2009/12/03 by Aurelien Campeas