## Why Stored Procedure taking extra time then , normal query execution(MYSQL)?

I have one stored procedure which returning single but taking 16+ seconds when I call that but only .5 second, if I run that by normal query.

Procedure

DELIMITER    DROP PROCEDURE IF EXISTS local_db.getAllMatchedStockByCompany    CREATE     PROCEDURE local_db.getAllMatchedStockByCompany(     IN Company_ID BIGINT(20)     )     BEGIN         SELECT t1.*     FROM ((SELECT t2.SRTitle,t2.UrlPart,t2.ScheduledTime,t2.Photo,TRIM(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING_INDEX(REPLACE(fnStripTags(t2.SRDescription),'&nbsp;',''),' ',             30), '\r\n\t\r\n\r\n\t', ''),'\r\n\t\r\n\t',''),'\r\n\t',''),'&rsquo;',''))AS Description, 'stock-research' AS from_tbl,t2.IsActive            ,t2.CompanyID FROM t2           ) UNION           (SELECT t3.ReportTitle,t3.UrlPart,t3.CreatedDate,t3.ReportImage,TRIM(REPLACE(REPLACE(SUBSTRING_INDEX(REPLACE(fnStripTags(t3.Description),'&nbsp;',''),' ',                 30),'\r\n\t\r\n\t',''),'&#39;','')),IF(t3.SpecialReport = 1,'special-report','report'),t3.IsActive         ,t3.CompanyID FROM t3           )          ) t1          WHERE CompanyID = Company_ID AND IsActive = 1          ORDER BY ScheduledTime DESC;     END    DELIMITER ;

the total execution time of this is 16 seconds with 1 row. But If I use below query

SELECT t1.*     FROM ((SELECT t2.SRTitle,t2.UrlPart,t2.ScheduledTime,t2.Photo,TRIM(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING_INDEX(REPLACE(fnStripTags(t2.SRDescription),'&nbsp;',''),' ',             30), '\r\n\t\r\n\r\n\t', ''),'\r\n\t\r\n\t',''),'\r\n\t',''),'&rsquo;',''))AS Description, 'stock-research' AS from_tbl,t2.IsActive            ,t2.CompanyID FROM t2           ) UNION           (SELECT t3.ReportTitle,t3.UrlPart,t3.CreatedDate,t3.ReportImage,TRIM(REPLACE(REPLACE(SUBSTRING_INDEX(REPLACE(fnStripTags(t3.Description),'&nbsp;',''),' ',                 30),'\r\n\t\r\n\t',''),'&#39;','')),IF(t3.SpecialReport = 1,'special-report','report'),t3.IsActive         ,t3.CompanyID FROM t3           )          ) t1          WHERE CompanyID = 931 AND IsActive = 1          ORDER BY ScheduledTime DESC;

It took only .5 to 1 seconds with one row.

Can anyone of you let me why this happening or How I can improve my SP execution time?

Thanks

## Can I regain some of my normal hit points while I have a buffer of temporary hit points?

If my character has 50 hp, loses 20 hp, and I then cast a 25 thp armor of agathys, what happens if I’m using something like Grim Harvest, Vampiric Touch or Enervation, each of which restore normal hp?

Obviously my pool of normal hp is depleted, do these spells replenish that even if I have a thp buffer on top?

## The replacement function is an integral and the double integral yields a different answer than the normal double integral

I am fairly new to Mathematica. I have a quick inquiry. The code is simple and just 3 lines. Trying to do a replacement rule as follows

ruletrr = intsl[exp_] :> Integrate[exp, {u, u, 1}] intsl[Integrate[a[u],{u,0,u}]]/.ruletrr

So basically I want replace the expression inside the square brackets after ‘intsl’ with integrating the expression from u to 1. The expression inside the square bracket is in fact an integral as well. The integrand is a function of u. However, after the second line, the answer is as follows

(1 - u)*Integrate[a[u], {u, 0, u}]

The answer means that Mathematica takes the expression inside the square bracker as a constant and not a function of u. Kindly copy the preceding line to see the integration symbol as I can’t do it here.

The problem is the first two line is equivalent to the following code line

Integrate[a[u], {u, u, 1}, {u, 0, u}]

The answers are different. Can someone let me know where is the mistake here or why is the integral evaluated.

The entire code input is as follows as a summary

ruletrr = intsl[exp_] :> Integrate[exp,{u,u,1}] intsl[Integrate[a[u],{u,0,u}]]/.ruletrr Integrate[a[u], {u, u, 1}, {u, 0, u}]

The first two lines are equivalent to the third line but the answers are different

## Is it normal that the service WMI Performance Adapter always starts when launching Chrome browser? Whats the reason

Is it normal that the service WMI Performance Adapter (WmiApSrv.exe) always starts when launching Chrome browser? Whats the reason?

I have heared this service can be maliciously used to “communicate” through the internet via open ports?

When I forcefull end this process in the taskmanager, Chrome keeps running perfectly, without issues.

Could it be that this WMI process is needed because one of Chrome’s features called “Conceal local IP addresses with mDNS hostnames”?

Thanks!

## How does browsers handle security for normal users? [duplicate]

• How does SSL/TLS work? 3 answers

A Casual user installs a browser (chrome/firefox/safari etc) and starts browsing the internet. How is the security protocols established for that user?

Majority of users that use the internet don’t import their certificate before using the browser. So how does the browser create certificates and establish protocols like SSL/TLS without getting any intel from the user?

Example:- Users get https connection on all the supported sites. So how does the browsers setup all the security parameters by itself?

## Can normal actions and magical actions be treated the same way and be allowed in D&D? [on hold]

I will give an example. I do everything that I can to frighten you; I glare at you, shout at you and bring my face closer. But there is no magic in it; I am just in that instance being terrifying. Could that be treated as a fear spell and given a spell level with consequences for the victim, even a loss of HP for them?

## Host moved to a new server – normal?

Dear WebHostingTalk.com,

I’ve been hosting multiple websites on a reseller plan with Host4Geeks after I had an awful experience with Hostwi… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1784506&goto=newpost

## 3D line segment AABB collision, with hit normal?

I’m embarrassed I can’t find this, but I’m wanting to detect intersection with a 3D line segment (not an infinite ray) with a 3D AABB, the AABB being defined as two Vec3f’s which represent the Min and Max extents. So the AABB can be arbitrarily-sized. I also need the surface normal of the AABB, if there was a hit.

From looking at similar algorithms I at least know it seems good to calculate the inverse direction of the line beforehand, at least, if you’re needing to check against multiple AABBs per frame.

I have

struct AABB {     VEC3F min;     VEC3F max; };  // a and b representing start/end points of the line segment // returns true if intersects, also fills out "normal" if true bool LineIntersectsAABB(const VEC3F& a, const VEC3F& b,     const VEC3F& inv_dir, const AABB& aabb,     VEC3F* normal);

The implementations I’ve found either do not find the hit normal, and/or they’re intended for boxes/cubes where the three dimensions of the box are always equal length, which doesn’t work for me. Implementations seem to vary greatly, which is confusing for me (who is trying to understand it), and, considering that I need the hit normal, I’d imagine that that may rule out certain implementations.

## An operational semantics for lambda-calculus normal order evaluation strategy

Under the normal order strategy, the leftmost, outermost redex is always reduced first.

I understand this as a restriction of the full beta-reduction evaluation strategy, whose reduction rules are given as follows:

$$\frac{t_1 \to t_1′}{t_1 t_2 \to t_1′ t_2}$$

$$\frac{t_2 \to t_2′}{t_1 t_2 \to t_1 t_2′}$$

$$\frac{t_1 \to t_1′}{λx. t_1 \to λx. t_1′}$$

$$\frac{(λx. t_1) t_2}{[x \to t_2] t_1}$$

My question is how to transform these rules so that the normal order strategy condition holds.