, 2009 0:32:03
Subject: Re: [U2] Universe Retrieve
Good point, Andy. I had considered that, but guessed that it would not be a
significant factor.
Just in case, I created a file with a million records, and reran the tests.
Here are the results:
COUNT TESTFILE WITH F1 = 'V'
Elapsed 7.4796
COUNT
environmental responsibility
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum
Sent: Friday, July 17, 2009 5:21 AM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve
Henry,
Yes, I did some more testing myself
Question: If you are doing a select statement and within the
statement you have a eval phrase and this eval phrase contains all
constants (ie, DATE() - 14), does Universe recalculate that constant
value with each record iteration or is it smart enough to know that this
is a constant value
-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
Sent: Thursday, July 16, 2009 8:39 AM
To: U2 Users List
Subject: [U2] Universe Retrieve
Question: If you are doing a select statement and within the
statement you have a eval phrase
or SORT and you'll see
what I mean
:)
Brian
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen
Sent: 16 July 2009 16:39
To: U2 Users List
Subject: [U2] Universe Retrieve
Question: If you
Hi Henry,
You can see the object code that is produced using VLIST and
examine it for optimizations.
The particular optimsiation that Barry is looking for would not show in the
object code. For a truly constant I-type expression, the query procesor
could evaluate it just once and store the
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips
Sent: Thursday, July 16, 2009 9:30 AM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve
Hi Henry,
You can see the object code that is produced using VLIST and
examine
Hi Henry,
I was under the impression that an EVAL calls the same compiler
that an I-type does, and that any expression optimization would be
done therein.
As far as I know, EVAL does indeed call the same compiler. As I think you
realise, the point is that an I-type expression such as
1:
] On Behalf Of Martin Phillips
Sent: Thursday, July 16, 2009 12:36 PM
To: U2 Users List
Subject: Re: [U2] Universe Retrieve
Hi Henry,
I was under the impression that an EVAL calls the same compiler
that an I-type does, and that any expression optimization would be
done therein.
As far as I know, EVAL
Hi Henry,
I did say not, so we are saying the same thing.
Whoops! I missed one word. Guess which one!
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
+44-(0)1604-709200
___
U2-Users mailing list
: Thursday, 16 July, 2009 18:36:27
Subject: Re: [U2] Universe Retrieve
Hi Martin,
I was under the impression that an EVAL calls the same compiler that an
I-type does, and that any expression optimization would be done therein.
Expanding beyond that, it would be interesting if the I-type compiler was
able
To: U2 Users List
Subject: Re: [U2] Universe Retrieve
Henry,
EVAL compiles the expression and writes the result into the dictionary, runs
the query and then deletes the dictionary item. For your test to be valid
you would need to ignore the overheads of the compile, write to and delete
from
12 matches
Mail list logo