[RBG7-L] - Re: View Speed

[David M. Blocker]

Steve   Perhaps an obvious question, but is CustNub2 indexed? Or does it have a foreign key constraint on it? This time sounds WAY slower than any simple indexed query I've ever run on any version of R:Base!   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Steve Breen To: RBG7-L Mailing List Sent: Tuesday, December 07, 2004 12:56 PM 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 Pager 800-668-8023 Cell 574-339-2356