[RBG7-L] - Re: View Speed

Tue, 07 Dec 2004 11:53:05 -0800

 
You may need to check other issues.  I have a table with 227516 rows, also with one customer having a very large amount of data. (about 30%).  Using the same statement below (substituting column names of course) my system responds back in less than 2 seconds.  I have a single column index on customer_no.
 
This is on an older Novel network, server running only 400 MHZ and typical run of the mill network cards/switches.
Work station is 2 GHZ, 512 Ram running XP. So the hardware setup certainly would not be considered leading edge!
 
Some things to consider:
 
Insure that you have an index on custnb2.
Insure that the index length is designated for as long as your customer id's are, or else it will not be
effective.
A database rebuild should be done on occasion to assist in speed, or at least rebuild the indexes.
Insure that your temp/scratch files are set for your local hard drive.
 
Other areas would be to insure network cards/switches etc. are all operating at peak efficiency with no conflicts.
 
Hope this helps, as I am not sure what else to look at.  It is a fairly straight forward query and I do not know
of anything faster than the simple Select statement.
 
-Bob
 
 
 
-------------- Original message --------------
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
Pager 800-668-8023
Cell 574-339-2356

 

Reply via email to