{"action":"created","issue":{"url":"https://api.github.com/repos/NCEAS/metacat/issues/324","repository_url":"https://api.github.com/repos/NCEAS/metacat","labels_url":"https://api.github.com/repos/NCEAS/metacat/issues/324/labels{/name}","comments_url":"https://api.github.com/repos/NCEAS/metacat/issues/324/comments","events_url":"https://api.github.com/repos/NCEAS/metacat/issues/324/events","html_url":"https://github.com/NCEAS/metacat/issues/324","id":302244872,"number":324,"title":"Metacat Performace: Rewrite the xml_nodes queries","user":{"login":"mbjones","id":766407,"avatar_url":"https://avatars0.githubusercontent.com/u/766407?v=4","gravatar_id":"","url":"https://api.github.com/users/mbjones","html_url":"https://github.com/mbjones","followers_url":"https://api.github.com/users/mbjones/followers","following_url":"https://api.github.com/users/mbjones/following{/other_user}","gists_url":"https://api.github.com/users/mbjones/gists{/gist_id}","starred_url":"https://api.github.com/users/mbjones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbjones/subscriptions","organizations_url":"https://api.github.com/users/mbjones/orgs","repos_url":"https://api.github.com/users/mbjones/repos","events_url":"https://api.github.com/users/mbjones/events{/privacy}","received_events_url":"https://api.github.com/users/mbjones/received_events","type":"User","site_admin":false},"labels":[{"id":822385528,"url":"https://api.github.com/repos/NCEAS/metacat/labels/Category:%20metacat","name":"Category: metacat","color":"ededed","default":false},{"id":822385150,"url":"https://api.github.com/repos/NCEAS/metacat/labels/Component:%20Bugzilla-Id","name":"Component: Bugzilla-Id","color":"ededed","default":false},{"id":822385527,"url":"https://api.github.com/repos/NCEAS/metacat/labels/Priority:%20Immediate","name":"Priority: Immediate","color":"ededed","default":false},{"id":854418426,"url":"https://api.github.com/repos/NCEAS/metacat/labels/Status:%20In%20Progress","name":"Status: In Progress","color":"ededed","default":false},{"id":822385145,"url":"https://api.github.com/repos/NCEAS/metacat/labels/Tracker:%20Bug","name":"Tracker: Bug","color":"ededed","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/NCEAS/metacat/milestones/9","html_url":"https://github.com/NCEAS/metacat/milestone/9","labels_url":"https://api.github.com/repos/NCEAS/metacat/milestones/9/labels","id":3157814,"number":9,"title":"Unspecified","description":null,"creator":{"login":"mbjones","id":766407,"avatar_url":"https://avatars0.githubusercontent.com/u/766407?v=4","gravatar_id":"","url":"https://api.github.com/users/mbjones","html_url":"https://github.com/mbjones","followers_url":"https://api.github.com/users/mbjones/followers","following_url":"https://api.github.com/users/mbjones/following{/other_user}","gists_url":"https://api.github.com/users/mbjones/gists{/gist_id}","starred_url":"https://api.github.com/users/mbjones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbjones/subscriptions","organizations_url":"https://api.github.com/users/mbjones/orgs","repos_url":"https://api.github.com/users/mbjones/repos","events_url":"https://api.github.com/users/mbjones/events{/privacy}","received_events_url":"https://api.github.com/users/mbjones/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":6,"state":"open","created_at":"2018-03-03T00:22:47Z","updated_at":"2018-03-05T10:26:07Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2018-03-05T10:26:07Z","updated_at":"2018-03-05T10:26:09Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"---\n\n\nAuthor Name: **Saurabh Garg** (Saurabh Garg)\nOriginal Redmine Issue: 2155, https://projects.ecoinformatics.org/ecoinfo/issues/2155\nOriginal Date: 2005-07-13\nOriginal Assignee: Jing Tao\n\n---\n\nFrom Matt's email...\r\n\r\nRewrite the xml_nodes queries.  In general we use the IN clause a lot\r\nwhich is less than efficient.  We need to evaluate how our current\r\nqueries are working and rewrite them. With some systematic work we can\r\nprobably come up with some similar ideas for improvements\n\n\n"},"comment":{"url":"https://api.github.com/repos/NCEAS/metacat/issues/comments/370375313","html_url":"https://github.com/NCEAS/metacat/issues/324#issuecomment-370375313","issue_url":"https://api.github.com/repos/NCEAS/metacat/issues/324","id":370375313,"user":{"login":"mbjones","id":766407,"avatar_url":"https://avatars0.githubusercontent.com/u/766407?v=4","gravatar_id":"","url":"https://api.github.com/users/mbjones","html_url":"https://github.com/mbjones","followers_url":"https://api.github.com/users/mbjones/followers","following_url":"https://api.github.com/users/mbjones/following{/other_user}","gists_url":"https://api.github.com/users/mbjones/gists{/gist_id}","starred_url":"https://api.github.com/users/mbjones/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbjones/subscriptions","organizations_url":"https://api.github.com/users/mbjones/orgs","repos_url":"https://api.github.com/users/mbjones/repos","events_url":"https://api.github.com/users/mbjones/events{/privacy}","received_events_url":"https://api.github.com/users/mbjones/received_events","type":"User","site_admin":false},"created_at":"2018-03-05T10:26:09Z","updated_at":"2018-03-05T10:26:09Z","author_association":"CONTRIBUTOR","body":"---\n\nOriginal Redmine Comment\nAuthor Name: **Saurabh Garg** (Saurabh Garg)\nOriginal Date: 2006-09-28T17:04:58Z\n\n---\n\n\nFollowing query can be used to replace the first IN clause\n\nselect distinct a.docid, a.docname, a.doctype, a.date_created, a.date_updated, a.rev  from xml_documents a LEFT JOIN xml_path_index b ON a.docid=b.docid where UPPER(nodedata) LIKE '%WATER%' AND path IN ('abstract/para','givenName','keyword','organizationName','title','surName', 'para','geographicDescription','literalLayout')  and b.docid is NOT NULL"}}
{"actor":{"display_login":"mbjones"}}