Subject Re: SLOW OPENING MDX FILE From Ed Furche <ed@univ-copputers.com> Date Fri, 23 Feb 2018 08:17:29 -0500 Newsgroups dbase.getting-started Mervyn Bick Wrote: > On 2018-02-23 12:37 AM, ED FURCHE wrote: > > I HAVE THOUSANDS  OF PLACES WHERE I OPEN OR CHANGE AN MDX FILE (SET ORDER TO XXXXX).  IN MY TIMEKEEPING.WFM FORM, IT TAKES 15-20 SECONDS TO OPEN OR CHANGE IT.  (NO FILTER IN EFFECT AT THE TIME.) > > > > > Please turn the %"@@% CapsLock off when you post in these newsgroups. > ALL CAPS is considered to be shouting. > > Most of us (certainly I do) get pissed off when shouted at and are, > therefore, quite likely going to ignore such messages.  Besides that, > ALL CAPS is harder to read than lower case.  People read by recognising > the "picture" of words and get far more practice on lowercase in day to > day reading.  As a result reading lowercase is more comfortable then > reading ALL CAPS. > > What version of dBASE? > > What version of Windows? > > How many records in the table? > > Has the table been packed recently? > > How many tags are in the .mdx file? > > Do all tags take as long to take effect? > > If only one tag is causing the problem what is it's index expression? > > Mervyn. > > Sorry about the caps. I have been chastised before about this. Answers: I haven't packed in a while. See the mdx's below: Production MDX file: WO.MDX           Index TAG: WOOPENWONO  Key: OPEN+WONO           Index TAG: WOOPENCUST  Key: OPEN+CUSTNAME1           Index TAG: PHONE  Key: WPHONE1+WPHONE2+WPHONE3           Index TAG: SHIPNAME  Key: SHIPNAME           Index TAG: LOC  Key: LOC           Index TAG: WOPRINT  Key: PRINTED           Index TAG: WOST  Key: ST           Index TAG: WODATE  Key: WODATE           Index TAG: WO  Key: WONO           Index TAG: WOCUST  Key: CUSTNAME1+WONO           Index TAG: WOINV  Key: WOINV           Index TAG: WOTECH  Key: TECH           Index TAG: WOSID  Key: SID           Index TAG: WODEPDATE  Key: DEPDATE           Index TAG: WOSERIAL  Key: SERNO1           Index TAG: WOSTTECH  Key: ST+TECH           Index TAG: WONAME  Key: RTRIM(TECH)+WONO           Index TAG: WOOPENTECH  Key: OPEN+RTRIM(TECH)           Index TAG: DATEOUT  Key: OPEN+TECH+DTOS(DATEOUT)           Index TAG: WOOPEN  Key: OPEN+WONO           Index TAG: POCLAIM  Key: CUSTPO           Index TAG: WOSMAN  Key: SMAN           Index TAG: WOSERIAL2  Key: SERNO2           Index TAG: WOSERIAL3  Key: SERNO3           Index TAG: CONTRNO  Key: CONTRNO           Index TAG: WOOPENNAME  Key: OPEN+RTRIM(TECH)+CUSTNAME1           Index TAG: EMAILSENT  Key: EMAILSENT           Index TAG: PARENTWO  Key: PARENTWO           Index TAG: BILLFLAG  Key: BILLFLAG           Index TAG: EQUIPMENT1  Key: EQUIPMENT1 i am trying to use the WO mdx whjich is on one field only (9 chars). Windows 7    dbase 2.8  16000 recs If i just go to command prompt and say:   Use WO   Set order to WO The prompt comes back immediately.   It is just in this one WFM that it is slow.  I ran a debug and it literally stops for 15-20 seconds when i address the WO MDX. Ed