FAQ-How to solve the problem of querying so slowly on client after so many devices be added or splited in R008?
After so many devices were added or splited in N2000BMS R008,sometimes open the ADSL、ServicePort windows or open the device panel will be so slowly .This is caused by the statistics ot sybase table ,so we need to update the sybase table statistics manually.
#isql -Usa -PXXX -SN2000DBServer ---XXX is the password of sa.
Execute follow script:
update all statistics ma5600v3_adsl_PortTab
update all statistics ma5600v3_pvc_CxcTab
update all statistics ma5600v3_pvc_VplVclTab
update all statistics ma5600v3_pvc_SrvFlowTab
update all statistics ma5600v3_gdm_ObjectTab
About the table like adsl or pvc ,we can modify it according to the Device type,like ma5600tv8 ,ma5100v2 and so on.