Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Wols Lists
On 24/05/13 15:57, George Gallen wrote: > In thinking about itI'm not sure, but it seems to increase the selection > speed (considerably). It is a type 30 file, > So possibly the index makes up for a hashing algorithm where the modulo is > too small? And the makeup of > The @ID causing more

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Perry Taylor
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, May 24, 2013 8:52 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? Maybe I am missing something, but why would you want an index on @ID? JRI -Origi

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread George Gallen
;s working. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, May 24, 2013 11:06 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? If you are doin

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Israel, John R.
, May 24, 2013 10:57 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? In thinking about itI'm not sure, but it seems to increase the selection speed (considerably). It is a type 30 file, So possibly the index makes up for a hashing algorithm where the mod

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread George Gallen
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, May 24, 2013 10:52 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? Maybe I am missing something, but why would you want an index on

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Israel, John R.
ay 24, 2013 10:10 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? George, I checked out system and we have experienced this issue before. Check if you have built an index on @ID. If you have, this is what is causing your issue. Using the NO.INDEX keyword will give y

Re: [U2] UV File doesn't like being sampled? (Work around)

2013-05-24 Thread George Gallen
l Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:18 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? YUP. I just isolated it to the index of @ID. I chang

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread George Gallen
List Subject: Re: [U2] UV File doesn't like being sampled? George, I checked out system and we have experienced this issue before. Check if you have built an index on @ID. If you have, this is what is causing your issue. Using the NO.INDEX keyword will give you correct results. I don'

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Charles Stevenson
George, Does the file have an index on the id? If so, try adding the "NO.INDEX" keyword. I've something similar @ UV10.2.10: -- >SELECT PARTS SAMPLE 2 26417 record(s) selected to SELECT list #0. - >SELECT PARTS SAMPLE 2 NO.INDEX 2 record(s) selected to SELECT list #0. - >DELETE.INDE

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Daniel McGrath
goes. Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 7:52 AM To: U2 Users Subject: [U2] UV File doesn&#

[U2] UV File doesn't like being sampled?

2013-05-24 Thread George Gallen
OK. Any Ideas? I have a Type 30 file that if I use the SAMPLE modifier in the SELECT still returns the entire file, However, if I use the SAMPLE modifier in a LIST command on that same file, it only returns the sample amount. Now, it gets stranger, If I do a SELECT with the SAMPLE modifier, it