Steve: I just run the following snippet: SET TIME FORMAT HH:MM:SS.SSS SET VAR vstart = .#TIME Sel MAX(tcost_all) into vtemp from wemp_file where slot_no = 'zm-07' SET VAR vend = .#TIME SET VAR velapsed = (.vend - .vstart) SET TIME FORMAT HH:MM:SS RETURN
velapsed = 150 The file wemp_file has 240,000 records, neither tcost_all nor slot_no have indices. The entire calculation takes 0.15 seconds (150 milliseconds) on my local laptop; even if you account for a network it should not take that long. You may want to rebuild your indices. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Parks Sent: Tuesday, December 07, 2004 12:03 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: View Speed 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
<<attachment: winmail.dat>>
