Arif Setyawan (@arifsetyaid) profile picture

๐Ÿ‡ฎ๐Ÿ‡ฉ Software Engineer

Balikpapan, Kalimantan Timur
Joined May 2009
Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)Photo by Arif Setyawan (@arifsetyaid)
Kopi tubruk adalah human right. Minum kopi tubruk pagi, siang, sore, malam adalah Asian value. Jangan tubruk yang lainโ€ฆ
3,911
17,428
4,461
77,445
4,713,047
Arif Setyawan retweeted
โ€œPantesan kejahatan di sini merajalelaโ€ฆ kita tidak punya Asian Valueโ€
1,289
10,412
469
44,991
2,245,287
Ini ada yang capture potongan tabel jurnalnya. As expected pada banyak yg salah ngambil simpulan. Atau telan mentah2 simpulan orang lain. Wasweswos #mbelgedhes
Replying to @alandakariza
Di Instagram pada ngomelin gue, katanya mungkin semua respondennya laki-laki~ Sampai gue cari artikel jurnal yang disadur. Kita udah bener kok ๐Ÿ˜… Respondennya laki-laki dan perempuan perokok. 95% perokok yang disurvey itu laki-laki. Artikelnya: journal.fkm.ui.ac.id/jurnal-โ€ฆ
50
Kayaknya salah ngerangkum iniโ€ฆ Sumbernya juga ga mudah diakses. Pure cari traksi ini postingan. #weakReference
This Post is from a suspended account. Learn more
1
75
Arif Setyawan retweeted
Laporan Keuangan Full Year 2023 GOTO sudah terbit GOTO tercatat rugi Rp 90,4 Triliun !!! Sebanyak Rp 78.7 Triliun di antaranya adalah Goodwill Apa itu Goodwill ? Mengapa bisa besar sekali ? BUKAN REKOMENDASI BUY SELL HOLD
35
651
51
2,518
384,986
Hujan akhir-akhir ini bikin cemasnya nda umumโ€ฆ
47
Aromanya menkopolhukam akan diisi sama opung lagi nih.
1
46
101 on how to become a young asshole โ€” samsul di debat cawapres tadi malam
44
Visi misinya capres dan cawapres bisa diunduh dimana ya?
68
๐—ง๐—ผ๐—ฝ ๐Ÿฎ๐Ÿฌ ๐—ฆ๐—ค๐—Ÿ ๐—พ๐˜‚๐—ฒ๐—ฟ๐˜† ๐—ผ๐—ฝ๐˜๐—ถ๐—บ๐—ถ๐˜‡๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐˜๐—ฒ๐—ฐ๐—ต๐—ป๐—ถ๐—พ๐˜‚๐—ฒ๐˜€ Here is the list of the top 20 SQL query optimization techniques I found noteworthy: 1. Create an index on huge tables (>1.000.000) rows 2. Use EXIST() instead of COUNT() to find an element in the table 3. SELECT fields instead of using SELECT * 4. Avoid Subqueries in WHERE Clause 5. Avoid SELECT DISTINCT where possible 6. Use WHERE Clause instead of HAVING 7. Create joins with INNER JOIN (not WHERE) 8. Use LIMIT to sample query results 9. Use UNION ALL instead of UNION wherever possible 10. Use UNION where instead of WHERE ... or ... query. 11. Run your query during off-peak hours 12. Avoid using OR in join queries 14. Choose GROUP BY over window functions 15. Use derived and temporary tables 16. Drop the index before loading bulk data 16. Use materialized views instead of views 17. Avoid != or <> (not equal) operator 18. Minimize the number of subqueries 19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join. 20. For retrieving the same dataset, frequently try to use temporary sources. Do you know what is ๐—ค๐˜‚๐—ฒ๐—ฟ๐˜† ๐—ข๐—ฝ๐˜๐—ถ๐—บ๐—ถ๐˜‡๐—ฒ๐—ฟ? Its primary function is to determine ๐˜๐—ต๐—ฒ ๐—บ๐—ผ๐˜€๐˜ ๐—ฒ๐—ณ๐—ณ๐—ถ๐—ฐ๐—ถ๐—ฒ๐—ป๐˜ ๐˜„๐—ฎ๐˜† to execute a given SQL query by finding the best execution plan. The query optimizer works by taking the SQL query as input and analyzing it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query. Next, the optimizer generates ๐—ฎ๐—น๐˜๐—ฒ๐—ฟ๐—ป๐—ฎ๐˜๐—ถ๐˜ƒ๐—ฒ ๐—ฒ๐˜…๐—ฒ๐—ฐ๐˜‚๐˜๐—ถ๐—ผ๐—ป ๐—ฝ๐—น๐—ฎ๐—ป๐˜€, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a ๐—ฐ๐—ผ๐˜€๐˜ to each execution plan based on the number of disk reads and the CPU time required to execute the query. Finally, the optimizer ๐—ฐ๐—ต๐—ผ๐—ผ๐˜€๐—ฒ๐˜€ ๐˜๐—ต๐—ฒ ๐—ฒ๐˜…๐—ฒ๐—ฐ๐˜‚๐˜๐—ถ๐—ผ๐—ป ๐—ฝ๐—น๐—ฎ๐—ป with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query. Check in the image the ๐—ผ๐—ฟ๐—ฑ๐—ฒ๐—ฟ ๐—ถ๐—ป ๐˜„๐—ต๐—ถ๐—ฐ๐—ต ๐—ฆ๐—ค๐—Ÿ ๐—พ๐˜‚๐—ฒ๐—ฟ๐—ถ๐—ฒ๐˜€ ๐—ฟ๐˜‚๐—ป. #technology #softwareengineering #programming #techworldwithmilan #sql
68
1,632
36
8,059
984,512
If you're looking for a new job, don't simply tell your interviewer: - "I've been a software engineer for 3 years" You should measure your own experience in qualitative terms. Not number of years. Try these ideas instead:
21
177
8
1,490
341,629
|๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ๏ฟฃ| | We Love Open-Source | |๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ๏ผฟ| \ (โ€ขโ—กโ€ข) / \ / โ€”โ€” | | |_ |_
116
1,239
69
12,172
969,009
Arif Setyawan retweeted
๐ŸŽ‰ Go 1.21 Release Candidate 4 is released! ๐Ÿƒโ€โ™‚๏ธ Run it in dev! Run it in prod! File bugs! go.dev/issue/new ๐Ÿ”ˆ Announcement: groups.google.com/g/golang-aโ€ฆ โฌ‡๏ธ Download: go.dev/dl/#go1.21rc4 #golang
9
66
3
317
38,868
Coding can be incredibly rewarding. There's nothing quite like the feeling of finally getting that piece of code to work, or solving a particularly tricky bug.
1
1
177
Finally, don't be afraid to ask for help. There's a common stereotype of the lone coder who never asks for assistance, but the truth is that everyone needs help sometimes. Don't be afraid to reach out and ask for it.
1
1
144
All in all, coding can be a challenging but incredibly rewarding journey. Stick with it, and don't be afraid to ask for help when you need it. You got this!
1
136