mysql where not in to left outer join -

-

i have following query , convert using left outer join instead of not in see if run faster way. it's taking query 40 seconds run on our database. i'm not familiar enough using outer joins type of thing convert myself.

select     c.contact_id contact_id,     c.orgid organization_id,     c.first_name first_name,     c.last_name last_name,     a.address_state state cnx_contact c inner join cnx_address on c.home_address_uid = a.address_uid a.address_state = 'oh' , (c.orgid = 45 or c.orgid = 55) , c.contact_id not in (     select pc.contact_id     cnx_contact c     inner join cnx_address on c.home_address_uid = a.address_uid     inner join cnx_contact_group_participant gp on c.contact_id = gp.contact_id     inner join cnx_contact_participant_role cr on gp.participant_role_uid = cr.participant_role_uid     inner join cnx_contact_group cg on gp.group_uid = cg.group_uid     inner join cnx_contact_group_participant pgp on cg.primary_participant_uid = pgp.participant_uid     inner join cnx_contact pc on pgp.contact_id = pc.contact_id     (c.orgid = 45 or c.orgid = 55)     ,   cr.name = 'applicant' ); 

select     c.columns cnx_contact c inner join cnx_address on c.home_address_uid = a.address_uid  left join  (subquery goes here) x on x.contact _id = c.contact_id a.participant_state = 'oh' , c.orgid in(45,55) , x.contact_id null;

Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more