Re: [sqlite] Views Optimization

Thanks for the answer guys... I'm afraid this is going beyond my SQL knowledge, so I'll let Stephane come back with a better example (when he gets his internet back :p) Guillaume Le vendredi 1 juin 2012 09:30:06 Richard Hipp a écrit : > On Fri, Jun 1, 2012 at 10:33 AM, Guillaume DE B

[sqlite] Views Optimization

Hi all, In Skrooge (http://skrooge.org), we use extensively views, and views based on views. However, it seems that in such a case, the linked views are computed several times. To better explain the issue, Stephane, our main developper, created a small use case, explaining the issue : CREATE

Re: [sqlite] SQLite related crash when starting Skrooge

Le lundi 21 mai 2012 17:30:24 Richard Hipp a écrit : > On Sat, May 19, 2012 at 3:35 PM, Guillaume DE BURE < > > guillaume.deb...@gmail.com> wrote: > > Hi guys, > > > > I am one of the developpers of Skrooge, an Open Source application for > > personal

[sqlite] SQLite related crash when starting Skrooge

Hi guys, I am one of the developpers of Skrooge, an Open Source application for personal finances management (http://skrooge.org). After upgrading SQLite to 3.7.12, our users report crashes upon starting the application : https://bugs.kde.org/show_bug.cgi?id=300183 Apparently, switching back