I have a big query that it execute in 4 minutes. (for example an important trigger)
I want to show situation of query or count of records that is affected in every 10 second in to a web page.
what should I do? (complete explain)
I have a class that being used to connect with the DB. Now I want to count how many times each web request executes the queries, but I've no idea where to store the counted value. I mean, Session wont, ViewState wont work as site also have webservices. What else I can use?
View 12 RepliesI have a query:
Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
When I am executing this query, it is taking 1-2 seconds to execute, but when I am using the same query in stored procedure, the below query is taking more than 5 minute:
If(Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12))
BEGIN
-- CREATE TEMPORARY TABLE [Say: #temp1]
#temp1 => Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
inserting the same value in the temp table
drop #temp1
END
what could be the reason of this? and how can I resolve this? I am running the SP from asp.net
Can any one please provide link for flow of query exection in sql
For eg.
FROM, [JOIN CONDITION, JOIN TABLE ...], WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, TOP
Suppose when we write query, how that query will get execute behind. I would like to know about that.
Can you please provide ariticles or link related to this
In my website, where majority of the users are from Norway,I access some values via querystring(eg: email address).Since the members' email ID may contain Latin letters,I am confused and blocked at this level.
My requirements are,
1, I need to access the Latin letters from query string. Is there any thing different from normal query string operations?
2, I need to store these latin Email IDs to my DB ,which is mysql.Any precaution to be taken while storing latin letters to mysql?
3, I need to show these stored email IDs in my web page.Should I use localization(which I have not used yet) for correctly displaying latin letters in webpage?
I am using the following code to ensure that the web pages in my website are not cached by the browser:
this.Response.Expires = 0;
this.Response.AppendHeader("Pragma", "no-cache");
this.Response.Cache.SetNoStore();
This is working fine & the browser displays a page with the message, "Warning. This page has expired....". Is there any way I can display a custom page instead of the default page shown by the browser?
I am recording time taken by a page to be displayed to user, for which I am recording execution end time in page_PreRender. But if the page contains huge amount of data, then it is taking few more seconds after PreRender event. I also tried with Page_Unload, still the same.
View 5 RepliesI would like to check how long an ASP.NET page takes to execute (server stuff obviously, not interested in how long it takes to throw the results down the line and for the browser to render them at this stage).
Having done some searching, I came across http:[URL] which shows how to do just this. Trouble is, it doesn't work for me. I copied the code exactly, but the execution time is always zero.
I tried enabling tracing, and that showed an elapsed time between Page_Init and Page_PreRender, but the values returned by Environment.TickCount were exactly the same in both events, so the elapsed time was 9obviously) zero.
isnt there performance analysis tools that i can use to monitor and trouble shoot things like timeout expired (slow query execution)?
I mean is there a way for me to monitor the query performance as it is run from the webpage. It runs perfectly in the SMS but it's slow when it's running from the webpages so it throws Timeout expired exception.
There is a possibility that the web server computer (host) resets and there is nobody that can log in to system after reseting . I dont want my webpage stop working at this state until the Admin login to the server. so I want my webpage do its main job at logoff state of the server.
how can I create this webpage? what technology can I use to do this?
In my code I am assigning certain values to labels from data reader.While debugging I can see that proper values are assigned but the changes are not reflecting in the end of debug on the webpage that are executing.
[Code]....
When the page is loaded for the first time the first row from the datareader is coming properly but after the click of next button change is not reflecting on the webpage.
I need to find out the query execution time from the front end .Where should I insert the code for that.
I am using the bleow query:
OracleConnection con = new
OracleConnection(ConnStr);
con.Open();
OracleCommand cmd =
new
OracleCommand("Stored_Proc",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add();
....................
................
OracleDataAdapter
oda = new
OracleDataAdapter
(cmd);
when i am executing a simple query it is takeing 47 sec .... that is only for one table.. other then that remaing table perfromance is good... Help me out... and is there chance to get good perfomance through .net coding..
View 3 RepliesI'm executing one stored procedure from the '.net' code. Since there is a lot of data, it is taking too much time to execute. Is there any way to stop this execution from the c# code?
In other words, if we execute the query from database itself, there is a option to stop its execution but in the code is it possible?
can anyone explain me how below query will execute internally ??
select sal from emp e1 where 3>(select count(*) ct from emp e2 where e1.sal < e2.sal)
i am using the transaction-per-request (session-in-view) pattern for an asp.net web application. I have a couple of points in the application where i want to Save an NHibernate managed entity and then do a couple of more inserts and updates using common sql. These inserts/updates depend on the ID that the NH saved entity will take.
The problem is that the generated id does not exist in the transactions' scope. If i force a flush/commit the id is persisted but if the inserts/updates fail i have to rollback but the flushed/committed entity will not. Currently I'm doing a manual insert for these cases but that is something i want to change. So, is there a way to execute the SQL statement (inside the already open transaction) after the Save() but without forcing a flush/commit?
EDIT: I'm adding a semi-pseudocode example, i got 4 wrong answers so i think people don't understand (how NHibernate works)
At the Begin request i issue a
nhsession.BeginTransaction()
then at some point i do
FooClass fc = new FooClass("value");
nhsession.Save(fc);
ITransaction trans = nhsession.Transaction;
SqlCommand sc = new SqlCommand("some insert/update query that depends on fc's id", (SqlConnection)nhsession.Connection);
sc.Parameters.Add("id", fc.Id); //NHibernate generates the id, note i'm using assigned/hi-lo so no round trip to the db takes place
transaction.Enlist(sc);
try {
sc.ExecuteNonQuery();
}
catch (SqlException ex){
transaction.RollBack();
nhsession.Close();
}
and at the end of the Request i issue a CommitTransaction() and nhsession.Close()
Now this will do absolutely nothing: the FooClass (fc) has not been flushed/commited to the database. The Save() operation that NH has done is up to that point in-memory. That means no sql command has been issued by nhibernate and that means that the SqlCommand (sc) that i fire afterwards will fail miserably as the id does not exist.
If i do a flush/commit between Save() and the SqlCommand the FooClass(fc) _cannot_be_rolled_back_ and that is a bad bad thing.Currently, for this to work i make vanila sql insert using an SqlCommand, and i want to change that. (Why? because i don't want to make vanilla inserts they are susceptible to errors due to schema/model changes, and i got the OR/M for that)
How? i want to notify NHibernate somehow to execute the SqlCommand to corresponds to the Save() insert (hell, it can do all the SqlCommands it has gathered) but without it commiting or flushing!.
Currently i'm also searching for the prepared sql statement that nhibernate produces when flushing/commiting a saved object. Maybe i can just take that string and run it in my SqlCommand that is enlisted in the Transaction.
I'm building an ASP.NET MVC site that uses LINQ to SQL. In my search method that has some required and some optional parameters, I want to build a LINQ query while testing for the existence of those optional parameters.
Here's what I'm currently thinking:
using(var db = new DBDataContext())
{
IQueryable<Listing> query = null;
//Handle required parameter
query = db.Listings.Where(l => l.Lat >= form.bounds.extent1.latitude && l.Lat <= form.bounds.extent2.latitude);
//Handle optional parameter
if (numStars != null)
query = query.Where(l => l.Stars == (int)numStars);
//Other parameters...
//Execute query (does this happen here?)
var result = query.ToList();
//Process query...
Will this implementation "bundle" the where clauses and then execute the bundled query? If not, how should I implement this feature?
i have a complex MSSQL query in my ASP.NET page with rows showing in GridView control.
I want to know what is the best solution for stopping the query if it takes more than X seconds to show in GridView.
I have an application that generates some rather large reports. I need the timeout to be greater than the default. I have added this to my web.config
<httpRuntime executionTimeout="360"/>
I made sure that in the advanced settings in iis that the connection time-out is set to 306
and also that the app pool idle time out is 5 minutes. However, when I send a request, my page still times out after two minutes.
I am working on a financial portal and I am having a problem..I don;t know what to call it so i mentioned it as an 'unknown to me' problem..I have a webpage..whenever I click on any button on my webpage, the request goes through..but nothing show up on the webpage..then If I click on another link and then again come back to previous link,then only I see the results of button_click..
e.g.
I have a currency conversion and investment form..so after filling up the form in following way and if I click on "INVEST" then nothing shows up..
so now if i click on any other link and go back to 'buy currency' link I see the result as 'investment successful'
I'm encountering a strange problem. Here is the scenario. I have built a query that accepts a parameter (WHERE LIKE clause).
I've tested this within the query builder and it returns exactly the number I would expect.
I then go back to my webpage and add the following controls:
Dropdown
Gridview
the user to make a selection from the dropdown. Postback on the dropdown is enabled so the page reloads and the Gridview displays the filtered results (via an objectdatasource). I've set the parameter to the dropdown control.
The trouble is when I run the page I make the selection in the dropdown no results are displayed. Even though the text displayed in the dropdown control is exactly the same as I inputted into the query builder when testing it.
i am new at reporting service things when i try to create a report i got this error and idea how to fix it
An error occured during local report processing.
An error has occured during report processing.
Qery execution failed for dataset 'ds_testtablosu'
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MMDB"
In my web application, I set the mode of session state as State Server and point to another server. After run some days, I always meet following exception:
The state server has closed an expired TCP/IP connection. The IP address of the client is 192.168.80.157. The expired Read operation began at 08/25/2010 14:18:03.
I have two tables --- Table1 has an identity column ID and a team name column and Table2 has columns where one column is one team's ID# and another column with the second teams ID# and other columns with scores for each team for that week.want to do a query to show that week's result but instead of the ID#, show the teams' names.
View 4 RepliesI am using multiple threads in my .net web application. Certain functions may need to execute at any arbitrary time. However, I do not need these (and the entire application) to be fully asynchronous, as there is an acceptable tolerance in this execution time. Here is a rough example of what I need to do:
main()
{
loop
{
if (flagA) then doTaskA();
if (flagB) then doTaskB();
}
}
...where flagA and flagB are set via asynchronous timers in critical section. The actual execution of the requested tasks would thereafter run in series.
This is very easy to do in C/C++, etc. But I cannot find any access to such control in .NET, specifically in the web server/application architecture. It may be that it doesn't exist; however, I am assuming that the server must do something of this sort as it manages applications. I would like to hook into that somehow; even if via some application function that is called regularly during this loop.