Scott: This is true. I just tested a file loaded on three different mvDbms products and got the following results (all Windows servers were rebooted before testing):
********** UniData on Dell 1425 w/2GB memory and 2SATA 80GB 7200 RAID0 drives ********** :TIME 15:48:50 Feb 17 2006 :SELECT GLPOST WITH CLIENTNO = "605" 21565 records selected to list 0. :TIME 15:48:57 Feb 17 2006 :CLEARSELECT :COUNT GLPOST 870120 record(s) counted. ********** D3 on IBM ThinkPad w/1GB memory and 1 60GB 7200 RPM drive ********** :time 15:53:15 17 Feb 2006 Friday :select glpost with clientno = "605" [404] 21565 items selected out of 870120 items. :time 15:53:38 17 Feb 2006 Friday :clearselect ********** UV on IBM ThinkPad w/1GB memory and 1 60GB 7200 RPM drive ********** :TIME 16:01:17 17 FEB 2006 :SELECT GLPOST WITH CLIENTNO = "605" 21561 record(s) selected to SELECT list #0. :TIME 16:01:32 17 FEB 2006 :CLEARSELECT SELECT list number 0 cleared. :COUNT GLPOST 870114 records counted. So, your milage may vary. Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Friday, February 17, 2006 2:13 PM > To: [email protected] > Subject: Re: [U2] [u2][ud] Poor select performance > > 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
