Apatar.com
|
Log In
Log In
close x
Login
Password
Remember me
Forgot Your Password?
Create Account
close x
First Name
Last Name
E-mail
Telephone
Message
Home
DataMaps
Downloads
Community
Documentation/Wiki
Report Bugs
Forums
Mailing Lists
ETL News
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Apatar Community Forums Forum Index
->
Help
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Font size
Tiny
Small
Normal
Large
Huge
Close Tags
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
All times are GMT
Jump to:
Select a forum
Apatar Open Source
----------------
Announcements
Installation and Upgrade
Help
General Discussion
Feature Requests
Downloads
Development
APPLICATION INTEGRATION AND CONNECTORS
----------------
New Connector Requests
Connectors Discussion
DataMaps
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thCornerL" width="22%" height="26">Author</th> <th class="thCornerR">Message</th> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>adminaia</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Wed Mar 21, 2012 9:38 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I speed up Join-Node #1 by filtering my 1st MySql-Node. <br />And my second Join-Node has only 20.000 values to match. <br /> <br />But it would be very nice if someone could check how to JOIN <br />3 tables in ONE SQL-Node. <br /> <br />Greetings</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>adminaia</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Mon Mar 19, 2012 8:34 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Ok, but actually I faced a problem joining 3 tables with inner join. <br /> <br />Two tables work fine: <br />Select * From `vtiger_contactdetails` Inner Join `vtiger_contactaddress` On contactid = contactaddressid <br /> <br />But this won't: <br />Select * From (`vtiger_contactdetails` Inner Join `vtiger_contactaddress` On contactid = contactaddressid) Inner Join `vtiger_contacscf` on vtiger_contactdetails.contactid = vtiger_contactcf.contactid <br /> <br />Or can I access a MySQL-View somehow?</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>adminaia</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Fri Mar 16, 2012 8:21 am<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Thanks for your answer, <br />it is pretty fast now! <img src="images/smiles/icon_smile.gif" alt="Smile" border="0" /></span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row2"><span class="name"><a name=""></a><b>Sergei</b></span></td> <td class="row2" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Mar 15, 2012 12:57 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hello, <br /> <br />You may try to write SQL query within MySQL connector to join two tables instead of using Join node. It would definitely speed up the process.</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>adminaia</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/subSilver/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Posted: Thu Mar 15, 2012 11:18 am<span class="gen"> </span> Post subject: Slow Join</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">Hello! <br />I'm working with apatar for a week and i think it is easy to learn. Brings fast solutions. <br />But today i faced a big problem while JOINING two MYSQL tables with about 370k records in. Each! <br /> <br />I build a first connector to table CONTACT and a second one to table ADRESS. Joining them all took hours (days?). I killed the job meanwhile. <br /> <br />Reducing the amount of values with WHERE lastname = 'smith' in table1 and where country = 'italy' in table2 will produce a fast result. <br /> <br />My second approach was to use the generic ODBC connector for mysql. It is faster to configure but i can not select different values with WHERE. <br /> <br />Any idea how to speed up?</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="templates/subSilver/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
Powered by
phpBB
© 2001, 2005 phpBB Group
Terms and Conditions
Privacy Policy
Contact Info
Comments and Suggestions
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in