sql server - Query takes 1.5 seconds in SSMS, but times out when run from .NET windows app? -

-

I have a query that is time to run from my windows application even though it runs fine within 2 seconds I run it directly in SSMS. All the other questions in the app go fine. I have also run a profile and confirmed that the app is actually running the query which I hope (when I get the code which is run by the programmer show app and run it in SSMS , It takes less than 2 seconds).

Long time running questions do not come in the app.

What's going on? 

  String result = dbHelper.GetTypedDataTable (dtMyProjects, "sp_get_DashboardPMMyProjects", MyUttivity.DW Connection, New String [] {"'+" + ShortNTID + "' '}); Static public string GetTypedDataTable (DataTable DT, string SSPN, string connection name, string [] arraypalmators) {if (connectionName == "default") {Setup Connection (SSPN, "sqlConn.ConnectionString", "SP"); } Other {Setup Connection (SSP, Connection Name, "SP"); } CmdSELECT.CommandText + = "" + arrayParameters [0]. Ostring (); Int countParameters = arrayParameters.Length; For (int i = 1; i & lt; countParameters; i ++) {cmdSELECT.CommandText + = "," + array parameter [i]. Ostring (); } Filtatable (DT) returns; } Private static zero SetupConnection (string SSPN, string connection name, string sqlType) {//sqlConn.ConnectionString = (string) (configurationAppSettings.GetValue ("sqlConn.ConnectionString", typef (string))); SqlConn.ConnectionString = ((string) (configurationAppSettings.GetValue (connectionName, typeof (string))); DaHlpr.SelectCommand = cmdSELECT; CmdSELECT.Connection = sqlConn; If (sqlType == "SP") {cmdSELECT.CommandText = "EXEC" + sSPName; } And {cmdSELECT.CommandText = sSPName; }} Private Static String FillDataTable (DataTable dt) {try {daHlpr.SelectCommand.CommandTimeout = 60; Dahlpr Fill (0, 1000000000, DT); } Hold (Exception pre) {return ex.Message.ToString (); } Return dt.Rows.Count.ToString (); // Returning the count of rows in the table}    
 
 
 Two seconds is a lot Long time these days, there should be a decent amount of essential processing.  
 If you are using a stored procedure, you may have to disable the sniffing of the parameter  
 Actually, on SP execution, immediately change each SP parameter into an immediate variable Archive. Here's a link with more details:  
  
 Also, though it can be obvious, sometimes it's easy to forget. These problems can be foiled on Dev Machine Reboot, SQL Server Service Restart, or SQL Server Machine Reboot.

Comments

Post a Comment

Popular posts from this blog

qt - switch/case statement in C++ with a QString type -

-
I want to use switch-case in my program but the compiler generates an error. How can I use the switch statement with QString ? The compiler gives me this error: The expression of the switch type 'QString' is invalid My code is as follows : boolStopWord (the word QString) {bool flag = false; Switch (word) {case "the": flag = true; break ; "On" case: flag = true; break ; Case "in": flag = true; break ; Case "your": flag = true; break ; Case "near": flag = true; break ; Case "all": flag = true; break ; Case "this": flag = true; break ; } Return flag; } How do I use the switch statement with a Caststring ? You can not use the switch statement in C ++ language with integral or enum types. You can formally enter the square type of object in the switch statement, but this means that the compiler will look for a user-defined conversion to convert it to an integral or enum type.
Read more

python - sqlite3.OperationalError: near "REFERENCES": syntax error - foreign key creating -

-
I'm trying to create a predefined key after checking the manual and I wrote it: Db.execute ("create table" Table 2 (id, integer primary key, somedata integer) "db.execute" (table creation table 2 does not exist (name text, maintain reference (id) ") and found this: sqlite 3. Operation error: near" references ": syntax error Your second ligne is wrong db.execute ("create table if table does not exist 2 (name text, my_id integer, foreign key (my_id) reference Maintenance (ID)) ") as explained
Read more

Python's equivalent for Ruby's define_method? -

-
What is a Python equivalent for Ruby's define_method , which is the dynamic generation of class methods will allow? (As can be seen in Wikipedia) Functions are first-class objects in Python and assign them The properties of a class or an example can be a way of doing the same thing as a Wikipedia example: colors = {"black": "000", "red": "F00", "green": "0f0", "yellow": "ff0", "blue": "00f", "magenta": "fff", "cyan": "0ff", "white": " FFF "} Class MyStream (ARR): Pass for Name, Code in colors.iteritems (): def _in_colour ( W code = code): return '& lt; Span style = "color:% s" & gt;% s & lt; / Span & gt; ' % (Code, self) setter (histrive, "in_" + name, _in_ color)
Read more