SV: [U2] [u2][ud] Poor select performance

2006-03-03 Thread bjorn.eklund
KT_REG WITH FAKT.FINR = 66 Bjvrn Eklund Anknytning: 2088 -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] John Jenkins Skickat: den 16 februari 2006 15:23 Till: u2-users@listserver.u2ug.org Dmne: RE: [U2] [u2][ud] Poor select performance Bjvrn You should

RE: [U2] [u2][ud] Poor select performance

2006-02-18 Thread Scott Ballinger
Subject: SV: [U2] [u2][ud] Poor select performance Sorry, that didn't help... Thanks anyway Bjvrn Eklund -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Perry Taylor Skickat: den 10 februari 2006 15:07 Till: u2-users@listserver.u2ug.org Dmne: RE: [U2] [u

RE: [U2] [u2][ud] Poor select performance

2006-02-17 Thread Bill Haskett
OTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Friday, February 17, 2006 2:13 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [u2][ud] Poor select performance > > I selected 311000 records on our new Linux Dell 6800 server > and it took 5 se

Re: [U2] [u2][ud] Poor select performance

2006-02-17 Thread Jerry Banker
ECTED]> To: Sent: Friday, February 17, 2006 1:58 PM Subject: RE: [U2] [u2][ud] Poor select performance -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 10, 2006 6:09 AM To: u2-users@listserver.u2ug.org Subject: [U2]

RE: [U2] [u2][ud] Poor select performance

2006-02-17 Thread Scott Ballinger
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 10, 2006 6:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] [u2][ud] Poor select performance [snip] Selecting a customer with 570 000 records can take 30 seconds

RE: [U2] [u2][ud] Poor select performance

2006-02-16 Thread John Jenkins
Bjvrn Oh yes - some reasonably recent enhancements in UniData processing of joins makes it worth re-checking any SELECTs with joins against a current version... Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [u2][ud] Poor select performance

2006-02-16 Thread John Jenkins
L PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 15 February 2006 17:27 To: u2-users@listserver.u2ug.org Subject: SV: [U2] [u2][ud] Poor select performance Hi JayJay, I guess you meant that I should create an index on the @id field. The keys look like this 66-112. I'm not sure if you say I

SV: [U2] [u2][ud] Poor select performance

2006-02-15 Thread bjorn.eklund
2-users@listserver.u2ug.org Dmne: RE: [U2] [u2][ud] Poor select performance Try building an index on the whole filed and using a RANGE selection ... i.e. >= and <= Let us know how it goes - it may do the job. Remember to use no.dups and no.nulls for a bit more pep (patter

SV: [U2] [u2][ud] Poor select performance

2006-02-15 Thread bjorn.eklund
Sorry, that didn't help... Thanks anyway Bjvrn Eklund -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Perry Taylor Skickat: den 10 februari 2006 15:07 Till: u2-users@listserver.u2ug.org Dmne: RE: [U2] [u2][ud] Poor select performance My experience is

RE: [U2] [u2][ud] Poor select performance

2006-02-10 Thread John Jenkins
rom: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 10 February 2006 13:09 To: u2-users@listserver.u2ug.org Subject: [U2] [u2][ud] Poor select performance Hi there, we are having very slow respone times on a select statement. We have a file with a total of 5 million

RE: [U2] [u2][ud] Poor select performance

2006-02-10 Thread Maresh, Mel
My pet peeve with Universe Indexes is in selecting multiple values of an indexed field The following select might take 10 minutes SELECT CONTRACT WITH I_CONTRACT = "50178227" "50092158" "50006089" "50178228" "50092159" "50006090" "50178229" "50092160" "50006091" "50178230" Whereas SELECT CONTRA

Re: [U2] [u2][ud] Poor select performance

2006-02-10 Thread robwills_u2list
Out of interest, how long does the selection take without the index? Regards, Rob Wills (rob dot wills at tigerinfotech dot com) Martin Philips wrote on 10/02/2006 14:04:26: > Given the number of records that you say are in the file, you are probably > going to visit most groups anyway so the

RE: [U2] [u2][ud] Poor select performance

2006-02-10 Thread Perry Taylor
Of [EMAIL PROTECTED] Sent: Friday, February 10, 2006 6:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] [u2][ud] Poor select performance Hi there, we are having very slow respone times on a select statement. We have a file with a total of 5 million records in where the key is like -nn.

Re: [U2] [u2][ud] Poor select performance

2006-02-10 Thread Martin Phillips
> Selecting other indexed values in the same file which gives me 5 records out > of the 5 million is very very fast. 30 second certainly sounds excessive but an index entry leading to over 500,000 records is not a good idea. To be effective, an index needs to lead you to a very small proportion of

[U2] [u2][ud] Poor select performance

2006-02-10 Thread bjorn.eklund
Hi there, we are having very slow respone times on a select statement. We have a file with a total of 5 million records in where the key is like -nn. The first part() is a customer number(numeric) and the second part(nn) is a sequential no. We have created an i-descriptor on the cus