-
Slow Response
Hello Gentlemen,
Hope you're ready for a good new year!
I'm doing some work with Enterprise again and I have a small problem.
I have written another page to display. It uses the same table as several other pages that I have already done, but this one takes a looooooooooong time to load (30 plus seconds sometimes). These are new fields that I have added to an old table. The other pages still load quickly.
Here is the code... Any ideas?
Set MyDb1=Server.CreateObject("ASPdb.ep"
MyDb1.dbMDB = Server.MapPath("../Level1/_database/logs2.mdb"
MyDb1.dbColor = "4,auto"
MyDb1.dbMode = "both"
MyDb1.dbSQL = "select TechNo,TechNm,MTech,SMTech,FSupv,MDoc,SMain,AMain, AFDemo,ASupp,PntAud,Calib,LeakTrac,DTProt,ATProt,S SForm,NCCklst,ADVFRL FROM [Techs] where Term='NO'"
MyDb1.dbImageDir="../level1/images/"
myDb1.dbNavigation="top"
myDb1.dbNavigationIcon="std"
myDb1.dbStatusBar="false"
MyDb1.dbNavigationItem="filter, resetfilter,update, add, delete"
MyDb1.dbUnit="4000"
MyDb1.dbGridInc=150
MyDb1.dbGridTableTag = "BORDER=1"
MyDb1.dbGridDisplayFlds="TechNo,TechNm,MTech,S MTech,FSupv,MDoc,SMain,AMain,AFDemo,ASupp,PntAud,C alib,LeakTrac,DTProt,ATProt,SSForm,NCCklst,ADVFRL& #34;
MyDb1.dbFormTableTag="Border=1"
MyDb1.dbFormDisplayFlds="TechNo,TechNm,MTech,S MTech,FSupv,MDoc,SMain,AMain,AFDemo,ASupp,PntAud,C alib,LeakTrac,DTProt,ATProt,SSForm,NCCklst,ADVFRL& #34;
MyDb1.dbEditParams="TableName=Techs, BookMarkFlds=TechNo, tabletag=border=2"
MyDb1.dbEditFlds="TechNo,TechNm,MTech,SMTech,F Supv,MDoc,SMain,AMain,AFDemo,ASupp,PntAud,Calib,Le akTrac,DTProt,ATProt,SSForm,NCCklst,ADVFRL"
MyDb1.dbEditDropFlds="MT,,Droplists,Certs"
MyDb1.dbEditUpdateROFlds="TechNo,TechNm"
nmap = "TechNo, <font FACE='Arial' SIZE=1>Tech Code</font>,;"
nmap = nmap & "TechNm, <font FACE='Arial' SIZE=1>Technician</font>,;"
nmap = nmap & "MTech, <font FACE='Arial' SIZE=1>MT</font>,;"
nmap = nmap & "SMTech, <font FACE='Arial' SIZE=1>SMT</font>,;"
nmap = nmap & "FSupv, <font FACE='Arial' SIZE=1>FS</font>,;"
nmap = nmap & "MDoc, <font FACE='Arial' SIZE=1>MD</font>,;"
nmap = nmap & "SMain, <font FACE='Arial' SIZE=1>SM</font>,;"
nmap = nmap & "AMain, <font FACE='Arial' SIZE=1>AM</font>,;"
nmap = nmap & "AFDemo, <font FACE='Arial' SIZE=1>AFD</font>,;"
nmap = nmap & "ASupp, <font FACE='Arial' SIZE=1>ASP</font>,;"
nmap = nmap & "PntAud, <font FACE='Arial' SIZE=1>15P</font>,;"
nmap = nmap & "Calib, <font FACE='Arial' SIZE=1>CAL</font>,;"
nmap = nmap & "LeakTrac,<font FACE='Arial' SIZE=1>LT</font>,;"
nmap = nmap & "DTProt, <font FACE='Arial' SIZE=1>DTP</font>,;"
nmap = nmap & "ATProt, <font FACE='Arial' SIZE=1>ATP</font>,;"
nmap = nmap & "SSForm, <font FACE='Arial' SIZE=1>SSF</font>,;"
nmap = nmap & "NCCklst, <font FACE='Arial' SIZE=1>NCC</font>,;"
nmap = nmap & "ADVFRL, <font FACE='Arial' SIZE=1>ADV</font>,;"
MyDb1.dbNameMap = nmap
mcell = "TechNo, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#TechNo#</font>;"
mcell = mcell & "TechNm, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#TechNm#</font>;"
mcell = mcell & "MTech, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#MTech#</font>;"
mcell = mcell & "SMTech, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#SMTech#</font>;"
mcell = mcell & "FSupv, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#FSupv#</font>;"
mcell = mcell & "MDoc, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#MDoc#</font>;"
mcell = mcell & "SMain, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#SMain#</font>;"
mcell = mcell & "AMain, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#AMain#</font>;"
mcell = mcell & "AFDemo, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#AFDemo#</font>;"
mcell = mcell & "ASupp, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#ASupp#</font>;"
mcell = mcell & "PntAud, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#PntAud#</font>;"
mcell = mcell & "Calib, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#Calib#</font>;"
mcell = mcell & "LeakTrac, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#LeakTrac#</font>;"
mcell = mcell & "DTProt, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#DTProt#</font>;"
mcell = mcell & "ATProt, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#ATProt#</font>;"
mcell = mcell & "SSForm, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#SSForm#</font>;"
mcell = mcell & "NCCklst, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#NCCklst#</font>;"
mcell = mcell & "ADVFRL, Align=left, <font FACE='Arial' SIZE=1 COLOR=Blue>#ADVFRL#</font>;"
MyDb1.dbMagicCell = mcell
MyDb1.ASPdbEP
Thanks,
Kim
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|