.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Alternative solution for prevmember to increase performance

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

I'm running several calculations, stored within the cube attached to the measure groups, which use "prevmember" as a navigation hint, to take the predecessor within the same hierarchy.

for instance


[dim time].[booking period].prevmember,



When requesting multiple members on the granular level, for instance 40 products, and placing the calculation within the columns, performance slows down with factor 6 in comparison to using currentmember. As one would think stepping the hierarchy shouldn't be so expensive I've tried different approaches.

Alternatives seem to be using "Scope" as well calculated dimension members. Could someone give me pros and cons or do you recommend something else?

We're Running SQL2005 SP2 enterprise

Business Intelligence professional

View Complete Post

More Related Resource Links

how to increase Performance onloading page and navigation of records ?? Help








this is my aspx and cs code , let me know whether it is correct or not??

onload and performance on navigation of record show be good.

Plz help me

<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True"

                DisplayGroupTree="False" ReuseParameterValuesOnRefresh="true" HasToggleGroupTreeButton="False" Height="1039px" ReportSourceID="CrystalReportSource1"

                Width="901px" />

            <CR:CrystalReportSource ID="CrystalReportSource1" runat="

Basic Instincts: Increase LINQ Query Performance


Jared Parsons demonstrates a technique to achieve maximum performance from LINQ queries on large sets of data in order to create a responsive user interface.

Jared Parsons

MSDN Magazine August 2008

MDX: Performance - Alternative to CurrentMember

Hi I'm trying to improve performance on an MDX query. Here is an analagous query that uses Adventure Works (2008 R2): WITH   MEMBER [Measures].[Marital Status]     AS [Customer].[Customer].CurrentMember.Properties("Marital Status")   MEMBER [Measures].[Gender]     AS [Customer].[Customer].CurrentMember.Properties("Gender")   MEMBER [Measures].[Yearly Income]     AS [Customer].[Customer].CurrentMember.Properties("Yearly Income") SELECT   {     [Measures].[Marital Status]     , [Measures].[Gender]     , [Measures].[Yearly Income]     , [Measures].[Internet Order Count]   } ON COLUMNS   , [Customer].[Customer].Children ON ROWS FROM [Adventure Works] Is there any alternative to the .CurrentMember.Properties("XXX") function, as this is having a significant impact on the running time of the query? Thanks, Julia.

Alternative solution to folder level permissions

I have a document library with multiple levels of folders that group sets of documents. Each folder has unique permissions setup. Ran into issue with URL length limitation because of multiple levels. I am looking at an alternative solution using meta data columns and views to categorize data. Everything is fine except I am not sure how to implement security akin to permissions on folder. How would I implement security based on meta data columns ? One soution that I can think of is creating workflows using SPD. Are there any other solutions for this ?

Need to increase performance. Any suggestions?


I have a report that runs from stored procedure and its a very hefty report with many many sums and margins and tons of graphs and things of the sort. I have it web based from asp.net and when my users run it it takes abour 3-4 before it actualy returns the long page of results.


Is there a better way to get this report out there faster? I was thinking...Is there a way to have the report ran once per day and then saved and anyone who runs the report will just get that saved report? Im not sure if anything like this exists, although i dont see why not. If anyone can give me any help to this it would be greatly appreciated! Thanks! 

How to increase performance of store procedure ?



I have written one store procedure for fetching huge data like this. there are nearly 2000 records. It is taking nealy 50 sec to execute. Could you tell me best method to fetch large no of

data ?

    ALTER PROCEDURE bulls_orbit.BuySellUpdateFetchData


    Select Id,Message,EndDate,RefId from tblBuySellUpdate Order By Id Desc


Sharepoint solution that calls WCF services has performance issues on production machines


I've a SharePoint solution that consists of set of webparts and other features. The webparts backend call a set of WCF web services. When I tried to install it on a production machine, it has some performance issues, I can open the page and wait for 30 min till it response to me.

If I call the same WCF services from a console application they works fine in both machines, if I creates a SharePoint team site it works fine in both machines, everything works fine on the dev machine.

The WCF services do some CRUD operations in a database and some API calls to SharePoint and PerformancePoint APIs

Development machines Specs:


Windows Server 2008 R2 Enterprise, 64-bit

Is there a significant Performance increase in upgrading from SQL 2008 RTM to SQL 2008 SP1



Is there a significant Performance increase in upgrading from SQL 2008 RTM to SQL 2008 SP1? I know it's best practice to keep your servers on the latest service packs. But I was also wondering are there any performance enhancements which could be gained from upgrading from SQL 2008 RTM to SQL 2008 SP1?

Also is there a document which states the key differences between SQL 2008 RTM to SQL 2008 SP1?

Thanks in advance,



If you have found any of my posts helpful then please vote them as helpful. Kieran Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Complete SQL Solution

SQL Server Solutions: SQL Server 2000/2005 Related Free Snippets.

ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.

10 Tips for Writing High-Performance Web Applications

Writing a Web application with ASP.NET is unbelievably easy. So easy, many developers don't take the time to structure their applications for great performance. In this article, I'm going to present 10 tips for writing high-performance Web apps. I'm not limiting my comments to ASP.NET applications because they are just one subset of Web applications. This article won't be the definitive guide for performance-tuning Web applications-an entire book could easily be devoted to that. Instead, think of this as a good place to start.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend