I selected 311000 records on our new Linux Dell 6800 server and it took 5
seconds on our E450 Solaris system 300000 records took 1 minute 45 seconds.
It all depends on how much power you're working with.
----- Original Message -----
From: "Scott Ballinger" <[EMAIL PROTECTED]>
To: <[email protected]>
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: [email protected]
Subject: [U2] [u2][ud] Poor select performance
[snip]
Selecting a customer with 570 000 records can take 30 seconds.
(example of statement SELECT A_FILE WITH FAKT.FINR = 66)
Selecting other indexed values in the same file which gives me 5 records
out of the 5 million is very very fast.
[snip]
And my guess is that selecting a customer with 250 000 records takes
about 15 seconds. This is likely normal, and probably as fast as you can
expect. Remember, that select (which takes 30 seconds) is building a
string of 570 000 ids and delimiters, then passing it (or a pointer to
it?) back to you. This will not happen instantaneously, even if
everything was already in memory.
/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
