Side comment:
I understand what Wil is saying and I think he has a valid point. But
I believe the value of the point is now insignificant. The tiny bit of
contention that Will brings up here is about just how much disk access
is done by any given process. Eliminate disk reads and the process
speed
dding more memory. Then go
home.
-Original Message-
From: Wjhonson
To: u2-users
Sent: Fri, Mar 8, 2013 2:48 pm
Subject: Re: [U2] Unidata index and short-circuit evaluation
I didn't miss it.
The point of the request, was from the beginning to the ending.
Of course the firs
t: Re: [U2] Unidata index and short-circuit evaluation
On 08/03/13 22:07, Wjhonson wrote:
> If your file is small enough, and your system idle enough that the file
remains *in memory* for all possible scenarios below, than you may not notice
speed issues.
>
> However, the monster in t
ri, Mar 8, 2013 1:17 pm
> Subject: Re: [U2] Unidata index and short-circuit evaluation
>
>
> On 08/03/13 21:03, Jeffrey Butera wrote:
>> While I'm on a roll... I often look at how to make queries run faster.
>> In short, we index all the commonly used data fields w
nced Bionics LLC
661) 362 1754
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera
Sent: Friday, March 08, 2013 1:04 PM
To: U2 Users List
Subject: [U2] Unidata index and short-circuit evaluation
While I'm o
are read again, then you should
run a single combined select which will do all accesses at the same instant.
-Original Message-
From: Wols Lists
To: u2-users
Sent: Fri, Mar 8, 2013 1:17 pm
Subject: Re: [U2] Unidata index and short-circuit evaluation
On 08/03/13 21:03, Jeffrey
On 08/03/13 21:03, Jeffrey Butera wrote:
> While I'm on a roll... I often look at how to make queries run faster.
> In short, we index all the commonly used data fields we can and (of
> course) it makes world of difference. However, I have some questions
> about optimal ways to query data using
While I'm on a roll... I often look at how to make queries run faster.
In short, we index all the commonly used data fields we can and (of
course) it makes world of difference. However, I have some questions
about optimal ways to query data using a mix of indexed data,
non-indexed data and i