-----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/
