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
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
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
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]
-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
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/
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
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
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
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
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
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
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.
> 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
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
15 matches
Mail list logo