Is Breakdat indexed? Perhaps if you created a compound index on Custnub2, Breakdat you could get an index only retrieval, which would be fast.
--- Charles Parks <[EMAIL PROTECTED]> wrote: > How about > > Create temp view tvMaster (custnub2, Breakdate) as select custnub2, > Breakdate from master where custnub2 = '6171' order by BreakDate Desc > > sel max(breakdat) into vTest1 from tvmaster where limit = 1 > > ________________________________ > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve > Breen > Posted At: Tuesday, December 07, 2004 11:57 AM > Posted To: RB7-L > Conversation: [RBG7-L] - Re: View Speed > Subject: [RBG7-L] - Re: View Speed > > > Tried this from the R: prompt as: > > set var vTest1 = n/a > > Then > > sel max(breakdat) into vTest1 from master where custnub2 = '6171' > > This works but this is one of our larger customers and it takes 60 > seconds or more to pull this data. > > Any other ideas. > > Thanks > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 07, 2004 12:35 PM > To: [EMAIL PROTECTED] > Subject: [RBG7-L] - Re: View Speed > > > > > Sel MAX(Breakdat) into varname from master where Custnub2 = > .vcust > > should work much faster, especially if you have an index on > Custnub2. Have an exit EEP from the customer ID field look up > the value as such. > > > > -------------- Original message -------------- > > Is there any way to speed up the following view or a > different method to be recommended for getting this information. I am > trying to display the date of the last time we handled a customers > business in a form as we enter the customer number in the form and begin > a new record. > > (custnub2, Breakdate) > Sel Custnub2, max Breakdat > from master > group by custnub2 > > Thanks for any help. > > Stephen Breen > CDI Services, Inc. > 3610 Deahl Court > P.O. Box 3838 South Bend, IN 46628 > 574-271-2027 Ext: 200 > Fax 574-247-4638 > Fax: 574-247-4631 > Email: [EMAIL PROTECTED] > Web Site www.911roadrepair.com > <http://www.911roadrepair.com/> > Pager 800-668-8023 > Cell 574-339-2356 > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
