Skip to main content
All docs
V23.1

Performance Optimization

  • 3 minutes to read

In modern database-connected client and server applications, multiple aspects can affect performance, such as:

  • Client computers or web browsers
  • Web server types, their geographic locations, software, and hardware (such as Azure compute units)
  • Database server engines along with their physical location and maintenance
  • Network communication and latency between system components
  • Custom application code and third-party libraries
  • Use-case scenarios (database record count, number of concurrent users, etc.)

Performance issues may occur both in XAF applications and non-XAF applications built from scratch. It is impossible to accurately determine the cause of performance issues and provide effective help without collecting quantitative data, for example, the number of SQL queries and their duration in database tables, execution time of .NET or JavaScript methods in problematic scenarios, network latency, or hardware specifications.

The best way to determine the underlying cause of performance issues is to profile application components with specialized performance profilers or loggers. Once you profile your application components and analyze the profiling logs, you will know exactly what contributes to performance delays and will be able to take further actions towards a solution.

If your XAF application has performance issues, we strongly recommend that you troubleshoot it as described in the steps below before you contact our Support Team. Without this profiling, the support team cannot help you resolve your issues properly.

Note

The DevExpress Support Team cannot profile full-scale projects or databases. If you or your team need assistance with such tasks, contact consultant companies that have expertise in XAF app development and performance profiling.

DevExpress API Performance

If your profiling results indicate a possible performance issue in DevExpress API, please contact our Support Team and include the following diagnostic information:

  • All the diagnostic information from SQL queries and application code articles.
  • Assets that will help our Support Team reproduce the issue locally in a typical development environment with only Microsoft SQL Server and Visual Studio installed. Please include a small debuggable sample project, database backups or demo data generation code, and any other supporting information.
  • A list of solutions you tried from the Data Request and ORM Performance and Application Performance - Troubleshooting articles and their results.

Performance in Additional Modules

Refer to the following topics to resolve performance issues in additional modules:

Video

In this video, we talk about the best ways to access and manage data in XAF and how to build high-performance applications.