Find Jobs
Hire Freelancers

MySQL expert with PHP knowledge for optimizations

$8-15 USD / hour

Closed
Posted over 6 years ago

$8-15 USD / hour

I'm looking for someone to make some specific changes to our existing architecture as well as recommend new ones. Please answer this at the beginning of your post: will JOIN return more or less data than RIGHT JOIN?
Project ID: 14767584

About the project

80 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
80 freelancers are bidding on average $13 USD/hour for this job
User Avatar
Right Join gives more data than JOIN (or Inner JOIN) Hi there I am interested in working on your project. Please give me full detail Thanks Rinsad
$15 USD in 40 days
4.9 (1264 reviews)
9.6
9.6
User Avatar
Join should return less data than right join. By join I understand you mean inner join. Right join will return less data than original right join if you make sure that the keys for the left table participating in the join is null. Inner join means only matched data whereas If I do a RIGHT JOIN, I get all the records that match and IN ADDITION I get an extra record for each unmatched record in the right table of the join . An Inner join would faster than right join. Having said that in one circumstance under which a RIGHT JOIN might be faster than an INNER JOIN, and that is when: Some of the tables are very small (say, under 10 rows); The tables do not have sufficient indexes to cover the query. If you are looking to take more tests I am ready for it. Please ping me asap.
$12 USD in 40 days
5.0 (260 reviews)
9.3
9.3
User Avatar
Hi, Right join doesn't work if column is not mentioned on which column you are joining two tables. So we need to use ON with right join. So, In that case If join is used with ON keyword too example --> join table b on a.id=b.user_id Then it will select less data than right join. But simple join works without mentioning the column on which column you want to join. In that case join will perform Multiplication of rows from both table. And will return a lot more data than right join. Our team members are highly skilled & have up to 14 Years development experience into web/mobile based applications. We have great experience on PHP, CodeIgniter , Angular 2, Ionic 2, SASS,Typecript, Node js Bootstrap, Phonegap, Cordova, ROR, MySql, Jquery, JavaScript, Ajax, HTML & CSS. Willing to discuss Thanks
$14 USD in 40 days
4.9 (198 reviews)
8.9
8.9
User Avatar
Hi there, will JOIN return more or less data than RIGHT JOIN? No . by using simple join we can get all data which will be match exactly
$12 USD in 40 days
5.0 (266 reviews)
8.5
8.5
User Avatar
Hello, LEFT JOIN return more rows because return row even if in joined table not exists associated row. Can you give more details about your project? Is you looking developer on long time? Regards Denis.
$16 USD in 40 days
5.0 (89 reviews)
8.3
8.3
User Avatar
(INNER) JOIN < RIGHT (OUTER) JOIN < FULL (OUTER) JOIN So JOIN (inner) return less data than Right JOIN. Share your existing architecture. Regards Arup B
$13 USD in 40 days
5.0 (170 reviews)
8.4
8.4
User Avatar
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$8 USD in 40 days
4.8 (471 reviews)
8.3
8.3
User Avatar
Hi, sir I have a great skill in php & mysql. I'm sure I can complete your project. My price and period is negotiable. We can discuss the details via chat. Thanks.
$11 USD in 40 days
4.9 (276 reviews)
8.0
8.0
User Avatar
Join return More data than right join, This is my answer and it will display publically on FL website. The joke on this website is if your not logged into FL and browse your project you can see all freelancers private message.
$16 USD in 40 days
5.0 (88 reviews)
7.8
7.8
User Avatar
Answer - Join will return less data than right join. Following factors makes me best candidate:- - Skilled in Php, Mysql with strong knowledge of database queries - Can make the changes on an existing web application - Available to discuss on freelancer chat or voice call => What are the changes need to be done on an existing web application? Looking forward to hear from you. Regards
$13 USD in 40 days
4.9 (68 reviews)
8.1
8.1
User Avatar
Hello, will JOIN return more or less data than RIGHT JOIN?---> Left JOIN will return more data. I am among top 1000 freelancer here, and well known for my quality work. I have delivered 200+ websites in last 24 months, I am very much interested to commence this project. I will certainly assist you to fulfill your project requirement with in quality time and budget. Technically I am competent in PHP (v5.5 & 5.6), CodeIgnitor, WordPress, Magento, Joomla, MySQL, HTML/HTML5, CSS/CSS3, Ajax, jQuery, Bootstrap v3, JavaScript etc. I am readily available to commence this project. Please, do ping me to discuss further. Regards, Brijesh R, Web Expert
$16 USD in 40 days
4.7 (253 reviews)
8.2
8.2
User Avatar
jpin returns records that have match in both tables right join will return all records from the right table even if there isnt a match in the other table . so if the right table has more records then right join will return more records than join in any case
$16 USD in 40 days
4.9 (337 reviews)
7.5
7.5
User Avatar
JOIN will return more data than RIGHT JOIN. Hello *I am ready to do your work((some specific changes to your existing architecture)) ASAP. So just send me your details for the kick start*** Thanks Mukesh
$12 USD in 40 days
4.5 (280 reviews)
7.9
7.9
User Avatar
Hi I can answer very easily Of course, Join returns less data than Right or Left Join. I have been developing web applications back-end for 6 years by using PHP, Mysql. So I can solve them easily. I hope to discuss more detail by chat. Thanks. @covernal
$20 USD in 40 days
5.0 (20 reviews)
6.8
6.8
User Avatar
Hello, I read the description and I’d love to help with this. I can do this for you. Let me look into but before that I need to know work details. Thank s
$15 USD in 40 days
4.7 (110 reviews)
7.5
7.5
User Avatar
Yes inner join will be less but other JOINs can be more or less than right JOIN Hi I am very,very interested in your project I have 6 years of web development experience such this projects. I am a highly skilled developer in full stack web development, cross platform mobile app development like Ionic, Xamarin, Unity, Phonegap, web scraping & crawling, reverse engineering and programming like c++,python,java,node js or something. Also I have already experienced with the job similar to this job. Please contact me. Looking forward to hearing from you soon. Best regards. bestit4u. Thanks
$12 USD in 40 days
4.9 (89 reviews)
6.9
6.9
User Avatar
Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore your needs, which will yield a clear picture of implementation phase. Prior undertaking project, I want to show demo of the work done previously. Apart from demo, I will be sharing following documentation which will turn your project into Quality and Successful delivery: - Technical Project Proposal - Designs - Flow chart for this Project - Execution plan Thanks
$11 USD in 40 days
4.8 (54 reviews)
7.1
7.1
User Avatar
less records We have a very experienced team with 6 years of experience in UI designer, Responsive Layout ,SEO, Web Development, Wordpress, Woo-commerce, Laravel, Cake PHP etc. So we would like to work with you and make professional business relation with you. Lets meet on chat for further discussion.
$14 USD in 40 days
4.7 (157 reviews)
7.2
7.2
User Avatar
JOIN will give less data then RIGHT JOIN. I am an expert in PHP & MySQL. I have been developing websites for last 7 years. Thanks!
$8 USD in 40 days
5.0 (2 reviews)
6.4
6.4
User Avatar
RIGHT JOIN will return more data in compare to just JOIN Hello Hope you are doing great!! Please share the existing URL with list of changes. I have 5+ years of web development experience with great projects in my portfolio. I am enabled with skills like MySql, HTML,JavaScript,CSS3,PHP with all its framework, etc. Let me know if you have any questions, I look forward to hearing positively from you for further collaboration. Regards Nikhilesh
$11 USD in 40 days
5.0 (19 reviews)
6.4
6.4

About the client

Flag of GERMANY
Los Angeles, Germany
5.0
5
Payment method verified
Member since Sep 29, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.