Notices


Reply
Thread Tools
Posts: 48 | Thanked: 51 times | Joined on Jul 2007 @ Austin, TX, USA
#1
I like Chrisoph Würstle's multilist application, but find it frustratingly slow: when clicking on an item to change its status, it takes about 2 seconds for the display to update.

Is this the normal behavior, or do I need to e.g. check my Python installation?

Henning
 
Posts: 48 | Thanked: 51 times | Joined on Jul 2007 @ Austin, TX, USA
#2
I did some more analysis of this problem and found that the >2 second delay occurs when doing the commit() for a simple UPDATE TABLE query.

The problem goes away when adding a "PRAGMA synchronous=0" to the code.

Is this considered an acceptable practice? It occured to me that his must be a common situation, since many applications use this paradigm where user input is immediately stored in the on-disk database.
 
Reply

Tags
multilist python

Thread Tools

 
Forum Jump


All times are GMT. The time now is 00:22.