Re: Performance problems with application roles

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Unkle Vo (isharko_at_yahoo.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 15:02:15 -0700

When Connection objects gets created it hesitates for a second or two(I
am using ADO.NET).

When I run same query I use in my app from QueryAnalizer it runs well.

When I use that same query in the AppRole context it is slow.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: How much time does a query take?
    ... not only the MSDE running, but also a visualisation for a part of a ... tell our app when a fault occured und when it went away. ... the app would execute a query against the database to retrieve the ... Like I wrote in my first question, in that way there can be a query every ...
    (microsoft.public.sqlserver.msde)
  • Re: SQl Data Provider Performance Issues
    ... Can you provide a complete sample app ... selects with a single inner join perforn OK. ... When I run the query from SQL ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Problem with an ADO query against SQL Server
    ... Debugging a hung app on the client side is another story... ... >>Use SQL server profiler to find out what "actually" is going on with SQL ... >>Server times out the query. ... >>> Or, was my program waiting somehow, for a response to the first query ...
    (microsoft.public.vb.database.ado)
  • Re: Convert Columns to Rows and insert into another table based on val
    ... The UNION query worked. ... FROM [ApplicationsServersGrid] ... I still get the 1s in the second column, not the app names and app ... ran in the Query Window for testing puroses, Also the Server may ...
    (microsoft.public.access.formscoding)
  • Re: Convert Columns to Rows and insert into another table based on val
    ... When I tried using the Union Query the last time using just 2 columns ... I still get the 1s in the second column, not the app names and app ... ran in the Query Window for testing puroses, Also the Server may ...  And each record would contain the servers LogicalName, ...
    (microsoft.public.access.formscoding)