通用查询：如何优化通用查询性能.pdf

1、Generic Inquiries:How to Optimize Generic Inquiry PerformanceSteven Houglum2AgendaIntroductionLearning ObjectivesSession OverviewLearning Objective TroubleshootingBusiness Scenario Use Case and SolutionDemoBenefits and ConsiderationsQuizLearning Objective Life CycleBusiness ScenarioUse Case and Solu

2、tionDemoBenefits and ConsiderationsQuizQ&ASummary and Key Takeaways3Presented bySteven HouglumSr.Director,Technology and Product4CPE DisclaimerThis session is NASBA-compliant,and you may get 1 CPE credit if you fulfill the following requirements:Participate in at least one quizProvide your full name

3、 and email address when you complete a quizFailure to provide your full name and email address will result in Acumaticas inability to recognize you in our reports;thus,we will be unable to issue a CPE certificate for you.If you are not interested in getting the CPE credit,specifying your personal de

4、tails is optional.Learning Objectives6Learning ObjectivesTroubleshooting with Acumaticas Request Profiler and Trace featuresBest practices in creating a Life Cycle approach to modifying or creating new Generic InquiriesSession Overview8Optimize Generic Inquiry PerformanceInquiries used throughout th

5、e system forScreen Lists,Reports,Dashboards,Events,Workflows,and moreDirect performance impact on all system activities and performanceInquiries execute in the same application instance and the transactional databaseDesign with performance in mindAvoid common mis-steps,timeouts and long running repo

6、rtsLearning Objective 1 Troubleshooting10Learning Objective 1 TroubleshootingDiagnose Problematic Generic InquiriesTrace FacilityRequest ProfilerSession Overview Troubleshooting12DiagnosisRetrieving actionable information is key to operational excellence for business.Generic Inquiries become natural