again.
ALl your advice was really precious, thanks a lot
2016-09-08 9:44 GMT+02:00 Simon Slavin <slav...@bigfraud.org>:
>
> On 8 Sep 2016, at 7:27am, Laura BERGOENS <laura.bergo...@imerir.com>
> wrote:
>
> > I took notes of everything you guys said, a
t; Chris
>
>
> On Wed, Sep 7, 2016 at 4:04 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
> >
> > On 7 Sep 2016, at 3:48pm, Laura BERGOENS <laura.bergo...@imerir.com>
> > wrote:
> >
> > > This query takes 100 seconds approx.
> >
> &
compile_options for the 3 platforms I mentionned before
and I tried to regroup the results in a libreOffice calc document, I don't
know if that can help or if it's relevant
2016-09-07 17:04 GMT+02:00 Simon Slavin <slav...@bigfraud.org>:
>
> On 7 Sep 2016, at 3:48pm, Laura BERGOENS <laura.berg
:
> Hi, Laura,
>
> On Wed, Sep 7, 2016 at 12:25 PM, Laura BERGOENS
> <laura.bergo...@imerir.com> wrote:
> > Hi Dominique,
> >
> > I guess it's not, but I'm not quite sure on what I can share, I'm a
> newbie
> > in a professional environment. I would b
ed, Sep 7, 2016 at 6:00 PM, Laura BERGOENS <laura.bergo...@imerir.com>
> wrote:
>
> > Then I create real tables in the in-memory clone that contain the content
> > of the views : INSERT INTO tableA SELECT * from viewA
> >
>
> What matters is how you create the
> Hi, Laura,
>
> On Wed, Sep 7, 2016 at 10:48 AM, Laura BERGOENS
> <laura.bergo...@imerir.com> wrote:
> > Note : I had some real queries that use to take 100 seconds to execute,
> and
> > I optimized them myself.
> > It looks like this :
> >
> &g
I've put ANALYZE in my code before running this SELECT query, I have no
change, and now on sqlite3.exe it runs kind of fast every time, even if i
close and re open the DB, without ANALYZE statement.
2016-09-07 17:15 GMT+02:00 Laura BERGOENS <laura.bergo...@imerir.com>:
> Ok I didn't kn
he product of the sizes of all the tables in the FROM clause
right?)
Here is what i can give you for now, now i'll do some tests that you've
recommended earlier
2016-09-07 16:33 GMT+02:00 R Smith <rsm...@rsweb.co.za>:
>
> On 2016/09/07 4:20 PM, Laura BERGOENS wrote:
>
>>
ry to come back at you asap
2016-09-07 16:24 GMT+02:00 R Smith <rsm...@rsweb.co.za>:
>
>
> On 2016/09/07 2:53 PM, Laura BERGOENS wrote:
>
>> Hello everyone,
>>
>> I tried to get some answers using the mailing list archives, but you guys
>> have been com
org>:
>
> On 7 Sep 2016, at 3:10pm, Laura BERGOENS <laura.bergo...@imerir.com>
> wrote:
>
> > I guess I don't have further question regarding my issue, since I have
> the
> > same time execution as with the sqlite3.exe tool, so there are no
> problems
> >
s you said that's not the place for
this question ;)
Thanks for replying again.
2016-09-07 15:19 GMT+02:00 Richard Hipp <d...@sqlite.org>:
> On 9/7/16, Laura BERGOENS <laura.bergo...@imerir.com> wrote:
> > Hello everyone,
> >
> > I tried to get some answers us
them.
Anyway, I was wondering why is there such a difference, I feel like the
pragmas are ok, and I've tested with same database, same queries.
Any ideas? Thanks for reading, if you guys need to know more I'm here
--
Laura BERGOENS
Technicienne supérieure en Informatique et étudiante à l'IMER
12 matches
Mail list logo