Slow performance running ordered query on SQL Server table with hierarchyid field -

-

I have a tree of classes stored in the table, which is currently a traditional parentcategoryId field And a hierarchy area called Eclllon

The following query is successfully sorted by a depth level in the format of data needed and by their depth and category name: 

  with q as c (c.Id, c.Name, c.Echelon, c.Echelon selection, NewEchelon as category c Zero is Zero and ParentCategoryId Zero Unions select all c2.Id, c2.Name, c2.Echelon, hierarchyid :: Parser (q.NewEchelon.ToString () + (more than ROW_NUMBER (). By order) NVARCHAR (max) + '/') from q to c2.Deleted include c2 class c2 and c2.Echelon.IsDescendantOf (q.Echelon) = 1 and c2.Echelon.GetLevel () = Q.Echelon.GetLevel () +1) Select * New order from the order by NewEchelon   
 The display of this query is unfortunately, not really great, there are only 319 categories in the actual table, and 89 of them To  Deletion of  has been removed soft with a non-null value in the column.  
 The time for that query is as follows:  
  Compile SQL Server's parse and time: CPU time = 0 ms, time passed = 0 ms (230 lines (S) Affected) SQL Server Execution Time: CPU time = 218 ms, elapsed time = 321 ms   
 Now one third of the other, I find this kind of small amount of data very strange It looks like there is no indexed one side of the package PK one in the table. Is it a way to rewrite it so that it's fast? Do I just need to add appropriate indexes? Should I collect a hierarchical order to generate with the above question, whenever the categories or their structure changes? Should I see class trees at the application level in caching?  
 My stomach tells me that this question should not be taken until it is not, and it is probably missing a trick, but I   
 < Div>  
 text "itemprop =" text "> 
 Processing time seems appropriate for me that it has a union query, some functions and one with   with     to take the sub-query processing time into account by using>

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -

-
"itemprop =" text "> I am writing applications that use WebSphere MQ to send messages. My unittests (for flow), I want to verify that I have put the correct message on the response queue. I am trying to figure out how to do this. My main obstacle is that I think it might be scary to clear the queue before running in my queue because the same queue can be used by other applications, I thought a decent solution would be a new line The manager will remove the queue for my solidarity and after using it. So my question is: Is it possible to use C # by using queue manager and queue? After the For future reference and future people, who want to make queues. I thought how to make and remove IBM MQ QE (not quenhers) with PCM messaging. It is not very simple, but it can be done. We have implemented it in a library and it is being used to create and delete commands before and after integration tests. The most important part of the code in this library is shown in the...
Read more