Why procedure and functions written in SQL are faster than functions written in Java for the same task?

like
Posting as :
works at
You are currently posting as works at

Because sql is just 3 letters and java is 4 so 3 < 4 and always faster

funnylike

Time to learn C

funny

Is stack overflow down??

funny

Sql is based on relational model and supports indexing.... Java is compiled and interpreted language... Java processes tasks not data and requires cpu resources..... Sql is like diving into an ocean and catching the desired fish or feeding the fish to make it fat......Java is like creating an ecosystem whithin an ocean which you can access at will

likehelpful

understood Thanks

like

Procedures and functions are pre-compiled codes in the database and are local to the database server. You can't run Java programs directly in the database. Java programs will be in the client server and will need database drivers to send data/parameters to the database through packages. As no driver connection is required to execute procedures and functions in the database network traffic will be less. Also when you will send data from the Java to the database through package it will take some time to load the package initially . In case of procedures and functions in the database there will be no initial loading as they are already compiled codes present in the database. Also the indexing and the inbuilt optimizer will help procedures and functions to process table data faster in case of database programs.

like

Related Posts

Sounding more and more like leaving EY during the Mercury rollout was the right move.

like

Hello all!
I'm 26, I studied economics but I don't know why I'm not much into investing/trading. Someone else like this?
I recognize this is not a very good approach for someone with money "knowledge" and I would like to change this mindset. My main weakness is that I easily get bored of following the market and that I do not see big opportunities. Any advice?
Where to start learning, general advice for LT and ST investments, things you learnt, books that changed your pov on the topic etc.

Thx!

like

Hearing rumours that Robinhood will limit ability to purchase 50 different companies. Does this mean those 50 are going to be on sale soon? Chance to buy at a good discount?

like

HI
Im looking for opportunity in react js. can anyone refer me @Mphasis
Have 4.5+yrs experiences.

TIA

Does anyone have a tool/ site that calculates what the offer would need to be to leave a current role, all things considered? Of course, it’s anything more than you’re making now, but I’m looking for something that accounts for LTE, the hassle, risk, etc.

like

How much should a senior email designer/developer make? I make 77k USD and feel like I’m underpaid. 😕

like

Which would you choose?

College experience plus networking and possible internships with other companies and roles or become a full time employee 85k at your current job while attending full time?

Currently I study and work full time but I’ve been thinking of leaving my job and taking a risk! More info on picture.

Thank you!

Post Photo
likesmart

What’s the best way to meet people in a new city? I’m lonely anyone up for a chat?

upliftinglike

I want to dispose my office chair and i live in Newton. Anyone knows if i can leave it curbside or where i can check for the details?

funny

Has anyone set up an NY 529 for their kids? Know there’s a 10k tax exemption for NY state taxes, but does anyone know if that per child, or across all children?

like

Does anyone know an Immigration Lawyer who also does legal malpractice cases?! My piece of s**** green card lawyer messed up my L1A and I ran out of time with my L1A to sign for a new GC!

like

Need 11likes for dm please

like

Hi All, My LWD is April 22, 2022
Please help me to get a referral in any organization supporting Permanent WFH/WFA

Skills: MS Sql Server, T-SQL, SSIS, Datwarehousing, GIT, MS Excel Macros, Basics of Python and PowerBI Exp: 1.6 years
Meesho Nagarro Coinbase Dropbox Facebook (Meta) Hotstar LogMeIn Lyft Okta Quora

like

"There's no whining in baseball!", said very seriously and earnestly ..... to the office dog.

likefunny

Hi All,

Can some1 tell me which company is better wells fargo or Natwest in terms of wlb, year on year appraisal, work culture and diversity candidate?

Thank You in advance

Just accepted a position in legal compliance at a F50 company. If I leave in a few years to get an LLM in a field I’m passionate about, would that make transitioning back to law more feasible?

like

Hi fishes,

What are the perks and benifits in Commonwealth Bank, I have recently got offer and i will be joining as a data scientist in aug.

Any leads wil be helpful.

Thanks

like

Anyone living in 14 and U street area know what they’re going to put in the space that “the Smith” just left?

like

What according to your experience during interviews has been one thing that you said or did made you get the job over 1000s of other applicants for a job, according to you? What is that one thing that made a difference and set you apart?

Just asking to learn from experiences.

like

Any of you auditors have pick up lines? Matched with a hot auditor guy and want to slide in

likefunnyhelpful

Additional Posts in Tech India

Bond is not legal in india
How to convey this to my company without getting any bad remarks
Suggestions please

like

What are good plant protein brands in India?

likefunny

Happy Diwali ✨ 🥳

Post Photo
like

Is a person bound to fail an interview if he is not prepared?
For this fear only,I am not applying to companies

like

What happens if the previous employer closes his organisation, will it fail my bgv

like

Need to buy an engagment ring and I am clueless. What should be the diamond carat?

like

I got offer from @LTI Lnt infotech,
31 LPA CTC.
P4 grade. Senior specialist.
Is it equivalent to manager role???
Is that CTC worth for the role??

9.3yrs exp. Java Full stack developer.

like

Which is the best company for a firmware engineer?

like

Is someone working for Collabera Inc. (Citibank Client)? I want to know about the wlb & if the company is good to join. HR said I wont be on contract & will be on permanent payroll of Collabera. I am not sure if I should leave my current company where wlb is amazing. Please suggest

like

Can you please suggest which one is better among logicmojo vs learnbay for Data Structures and Algorithm Instructor led course?

Please share your experience if any.

like

are you satisfied with your job? why?

like
like
like

How many companies come to PwC for react/ frontend development? This is my first time in Service based company and its been only one month since I am here. Will I have to sit on the bench for long?

like

How not to take as personal if your manager blast in group of people even for small mistake or not even considerable as mistake.
How do you keep yourself don’t get effected and without any guilty?

like

Hi guys , Iam holding an offer with Comcast 12.5 lpa (12 fixed) and Empower retirement 16 LPA (14 fixed) . Iam very much confused. Please provide some suggestions on which one to choose?

like

Hello Everyone,
Hope everyone is doing well.
Can anyone help me please how many leaves we get per annum in Barclays ??

Hi Fishes,
Need 11 likes to unlock DM. Thanks in advance

like

Larsen & Toubro Infotech How is LTI for scrum master role? And any idea on pay range?Larsen & Toubro Infotech

like

Hello Fishes,

I currently hold offers from below:
IBM - 15.5 LPA
CTS - 18.5 LPA
PWC India - 16 LPA
Oracle Financial Services Software(OFSS) - 21 LPA

Planning to join OFSS as I will work in product development team and can work in any shift timings with WFH.

Today I had my 2nd round interview with EY GDS and got rejected.
Do I need to worry about this and feel low?
Could EY GDS would have been better instead of OFSS?

Please provide your valuable inputs.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal