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


Post New Web Links

AssociatedMemberGroup taking so much time while iteration?

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :SharePoint
 

I have around 80 sites and sub sites. I trying to find user has contribute rights for the site group. But our each contribute group has around 100K users. So this AssociatedMemberGroup  taking so long for iterate each site. Is there any way we can use SPQuery to make it fast? Or any other do this?

 

eweb.AssociatedMemberGroup.Users[user.LoginName]

 

Please help me out.


ItsMeSri


View Complete Post


More Related Resource Links

Why the Same sql query taking much more time in other server.

  
Hi All,   I have a sql query.. which is running absoulutely fine in the production environment. I restored the Prod DB to another server.. same hardware and software configuration as Prod server. But in that server the same query taking ____ lot of time.. What could be the reason ??SD

Restoring Database taking long time in SQL Server 2008 R2 -- some how urgent

  

Hi all

I have Database size 12GB in SQL Server 2005 and It is backed up.

Now I tring to restore Database in SQL Server 2008 R2(wizard)....it is not at complted after 2hours...still running.

 

any idea..or help appreciated..

 


SNIVAS

WCF calling webservice - assigning return value taking a long time

  
0 down vote favorite

I have a wcf service (WCF_A ) which calls another wcf service (WCF_B) (currently I am hosting the WCF_B on my local machine with my credentials – as windows service), WCF_B internally makes a call to a webservice (WS01) that is hosted on the IIS. I have created a test client and call the WCF_A -> WCF_B -> WS01. Just before making the call to (WS01) I start a timer and I stop the timer when the webservice call comes back and the result is assigned to a variable, the flow is as below WCF_B

1)  Debug.WriteLine(“Call to webservice”) 
2)  Starttimer 
3)  Var result = WS01.Function(xxxx) 
4)  Stop

wsp files taking alot of time to deploy

  
In order to integrate SSRS 2008 with MOSS 2007, we added a server as a WFE on the farm. this wfe has SSRS 2008 configured. but after that the wsp files, though not giving any error... are taking more than 30 minutes to deploy and retract... the configuration of the farm is simple too. 2 front end, 1 search and 1 database. i have tried restarting the timer service and turning the timer service off on the wfe2 (where SSRS 2008 is also present).... any ideas?
Adnan Shamim

Hi can u please explain me WWF taking real time scenario / live project

  
please explain me WWF  taking real time scenario / live project

SSRS taking a long time to run an MDX query

  

Hi,

I have an MDX query which runs fine in the MDX Sample Application. It runs against an SSAS 2000 cube. In my query there is a recursion kind of a logic. It takes about 1-2 sec to run in the MDX Sample Application. My sample application is in the same server as my AS 2000 cube is. However when I run the same MDX from another server through BIDS (2008) it takes an unusually long amount of time to run. Most of the time it times out. :(

As a workaround I created 4 calculated members in my Cube itself (Initially these were used as members in my MDX). I thought that maybe the recursion logic is the culprit so I modified my MDX, removed the recursion part. But still from my SSRS it is taking a long time.

Any pointers to where I am missing the trick ?

Thanks in advance,

Suman


ASP.NET upgrade seems to be taking a very long time to start

  

At work I'm tryhing to upgrade an ASP.NET 2.0 app (which we wrote using VB.NET 2005) to ASP.NET 4.0.  I had a few problems during the upgrade, but eventually worked them all out.  At the end of the day I decided to give it a quick compile and see if I'd get the start page, so I hit F5 in VS 2010.  I left it that way, and man was it acting weird.  VS 2010 wasn't responding to anything.  If I hovered the mouse over VS 2010's minimize or close buttons, in the upper right corner, then those buttons were flashing very rapidly.  I'm not sure what was going on.  After waiting 15 minutes to see if it would come up, I decided to try clicking on the close button.  Nothing happened.  Eventually, I had to leave (I take public transit, and I have to leave when the bus comes), but I thought I'd leave it going as is, in hopes that it might fix itself.

But what I want to know is this, is this pretty standard behavior?  Does it normally take this long to do this?  This website is of modest size (<100 pages).


SQL Query is taking long time to run

  

Hi All,
SQL Query is taking long time to run in my report. It is using Clustered index seek when I am querying for 2 days on invoice_itemized table. It is returning 99 thousand records. It is returning  2524094 records and it is using clustered index scan when I am querying for one month. For one month It is taking 7 minutes.
Basically it is not using the index defined for the store_Id, status and datetime columns in the invoice_totals table. Can I force the sql query to use the specified index?

Please suggest me to improve the performance....

SQL Query
=========

SELECT
Invoice_Totals.Store_Id
,Invoice_Totals.DateTime InvoiceDate
,Invoice_Totals.Invoice_Number
,Invoice_Totals.CustNum
,Invoice_Totals.Cashier_Id
,Invoice_Itemized.ItemNum
,Invoice_Itemized.DiffItemName
,Invoice_Itemized.Quantity
,Invoice_Itemized.origPricePer
,Invoice_Itemized.PricePer
,Invoice_Totals.Discount InvDiscPercent
,Invoice_Itemized.LineDisc LineDiscPercent
,CASE
WHEN Invoice_Totals.Total_Price <> 0 AND Inventory.ItemType=7 AND Invoice_Totals.Discount = 0 THEN ((Invoice_Itemized.PricePer * Invoice_Itemized.Quantity) * -1) / ((Invoice_Totals.Total_Price) + ((Invoice_Itemized.PricePer * Invoice_Itemized.Quantity) * -1))
WHEN Invoice_Totals.Total_Price <> 0 AND Inventory.ItemType=7 THEN ((Invoice_Itemized.PricePer * I

Stored Procedure taking time in execution

  

Dear All,

 

I am breaking my head on this issue since long. I have stored procedure in MS SQl and when I try to execute that procedure by providing all the parameters in SQL Query, it takes long time to execute but when I try to directly run the query which is there in SP it executes in no time. This is affecting my application performance also as we are using stored procedures to fetch the data from DB Server.

Please help.

Regards,

Vikram


Vikram

SSIS Package Validation Taking Long Time

  

Hi,

The package that I am workin on used to open in BIDS real quickly and also when running it through BIDS. Now, it is taking a long time to open in BIDS and also when I am executing it using DTEXEC it is taking more than 60 minutes just for validation.

I dont consider it as heavy as it has fewer tasks compared to other packages and they open really quickly. And also I can open the package to work offline, but have issue with it while executing the package using DTEXEC.

I have tried DelayValidation=TRUE, but it is not much of a help.

Sriram

 


MDX Query in SSRS Dataset taking more time

  

Hi All,

I have  created report based on below mention MDX query ,but it will take more time say of 10 mins to execute.while other report having bulky data in their datset working fine.

Kindly suggest how do i optimise the Query so it will take less time

 

with

member [measures].[A]as
iif([Measures].[CALLSHANDLED]=0,0,[Measures].[HANDLETIME]/[Measures].[CALLSHANDLED])


member [measures].[B]as
iif([Measures].[Avg After Call Work]=0,0,[Measures].[Avg After Call Work])


member [measures].[C]as
iif([Measures].[Staff Time]=0,0,[Measures].[CALLSHANDLED]/[Measures].[Staff Time])


member [measures].[AA] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[A] )
member [measures].[BB] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[B] )
member [measures].[CC] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[C] )


 member [measures].[Rank_Avg_Handle]as
(filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members,
iif([Measures].[CALLSHANDLED]=0,0,
[Measures].[HANDLETIME]/[Measures].[CALLSHANDLED])>[measures].[AA]).count)


 member [measures].[Rank_Aft_Avg_Call]as
(filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members,
iif([Measures].[Avg After Call Work]=0,0,[Measures].[Avg After Call Work])>[measures].[

Stored Procedure taking time in execution

  

Dear All,

 

I am breaking my head on this issue since long. I have stored procedure in MS SQl and when I try to execute that procedure by providing all the parameters in SQL Query, it takes long time to execute but when I try to directly run the query which is there in SP it executes in no time. This is affecting my application performance also as we are using stored procedures to fetch the data from DB Server.

Please help.

Regards,

Vikram


Vikram

upgrading/attaching contentdatabase is taking more time

  

Hi, 

I am trying to run an in-place upgrade in from WSS 2.0 to 3.0.  WSS was upgraded successfully. I have created a website as well.. i was trying to add the content database, it is taking more time to process. Its getting struck at this step. It was struck for more than 1.5hrs. Please help me. I am in a big trouble if i dont complete this today. After this log event, there are no steps taken for more than 1.5hrs.

 

[SPManager] [DEBUG] [10/30/2010 5:39:37 PM]: [SPContentDatabase Name=<contentdatabsename> Parent=SPDatabaseServiceInstance] Running 1 of 88 steps

[UpgradeForIssueTracker] [3.0.52.0] [DEBUG] [10/30/2010 5:39:37 PM]: Begin Initialize()

[UpgradeForIssueTracker] [3.0.52.0] [DEBUG] [10/30/2010 5:39:37 PM]: End Initialize()

[UpgradeForIssueTracker] [3.0.52.0] [INFO] [10/30/2010 5:39:37 PM]: Issue tracker use V3 versions feature.

[UpgradeForIssueTracker] [3.0.52.0] [DEBUG] [10/30/2010 5:39:37 PM]: Begin Upgrade()

[UpgradeForIssueTracker] [3.0.52.0] [DEBUG] [10/30/2010 5:39:37 PM]: SqlCommand.CommandTimeout = 0




Webservice taking time while using Speech Recognition API's

  

Hi,

 

I am using the Speech Recognition to convert speech to text.

i/p is WAV file and o/p should be text.

Cod:

        public string GetConvertedText()
        {
            string str = "";
            //StringBuilder Output = new StringBuilder();
            try
            {
                SpeechRecognitionEngine RecognitionEngine =
                    new SpeechRecognitionEngine(new System.Globalization.CultureInfo("en-US"));
                //new SpeechRecognitionEngine(new System.Globalization.CultureInfo("ja-JP"));

                //load grammar
                Recogniti

OLE DB Destination is taking more time to commit.

  

I am using a OLE DB desitination to load a SQL Server 2000 database table. The volume of the data is .38GB (2357536 rows). The package execution is taking more time to commit. The data tree shows that the data has been reached the OLE DB destination, but not committing. I have set the DefaultBufferMaxRows to 10k as suggested in one of the post. Still my OLE DB destination is taking more time to commit. What could be the reason? Please help.

Thanks in advance

Ravi.S


Round off time to the nearest minute

  
How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

  
Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.
Categories: 
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