Joomla ServiceBest Web HostingWeb Hosting
Home Services

Query Performance

So you have a query that is logically correct and returns the data you require. But there's a problem - it's much too slow. Understanding why and figuring out how to improve query performance can be time-consuming and difficult.

SQL and MDX queries require different approaches. For SQL, the Query Analyser is the best place to start, focusing on join methods and index usage.

For MDX, the SQL profiler is a useful tool, enabling the use of aggregates to be investigated as well as determining where bulk vs iterative calculations are being performed.

moyogi can help improve your query performance by analysing why a query is slow and recommending code or database modifcations and, if necessary, changes in approach.