razinal (@sud0su) header
razinal (@sud0su) profile picture

Tukang == {{ }} | {% %} | ? ?

Banda Aceh
Joined March 2010
Photo by razinal (@sud0su)Photo by razinal (@sud0su)Photo by razinal (@sud0su)Photo by razinal (@sud0su)Photo by razinal (@sud0su)Photo by razinal (@sud0su)Photo by razinal (@sud0su)Photo by razinal (@sud0su)
menarikkk niii
9
Lagi nyoba bikin indikator Bandar Flow nih, khusus buat ndeteksi kapan saatnya bandar mulai ngegass! ๐Ÿš€๐Ÿ“ˆ #Saham
22
๐Ÿšจ JANGAN SAMPAI KETINGGALAN! FREE TRIAL BANDARMETRICS RESMI DIBUKA ๐Ÿšจ Ini kesempatan terbaik untuk merasakan langsung pengalaman menggunakan website Bandarmetrics. ๐Ÿ“… Periode Claim: 4โ€“10Agustus 2026 ๐ŸŽ Durasi Trial: 7 Hari (setelah verifikasi) Cara Claim: โœ… Follow X @bandarmetrics โœ… Share/Repost postingan launching ke Media Sosial kalian. โœ… koment pada postingan dengan menyertakan hashtag #FREETRIALBM dan tag 2 temanmu โœ… Registrasi akun di bandarmetrics.com (khusus user baru) โœ… Upload bukti follow & share saat registrasi ke website Bandarmetrics โœ… Join Grup Telegram BM community setelah terverifikasi mendapatkan Free trial t.me/+14N_2Ue6rV02ODk9 Syarat & Ketentuan: โ€ข Khusus pengguna baru/ Pengguna Paket Basic (belum pernah berlangganan Pro Package). โ€ข 1 orang hanya boleh memiliki 1 akun (akun ganda didiskualifikasi). โ€ข Akun tidak dalam kondisi lock / Private saat melakukan claim. โ€ข Verifikasi maksimal 1ร—24 jam. โ€ข Free Trial tidak dapat dipindahtangankan atau diperjualbelikan. โ€ข Free Trial akan berakhir otomatis (tanpa auto-renewal). โณ Periode terbatas! Jangan sampai kelewatan kesempatan ini. ๐Ÿš€
175
223
25
217
23,622
Say goodbye to expensive software! 10 websites that can replace hundreds of dollars worth of PC software (for free) Your wallet will thank you later! ๐Ÿ’ธ
39
458
8
1,403
321,665
Stop paying for expensive PC Software's 10 Free Web Apps That Can Replace Your PC Software: [๐Ÿ”–Bookmark for later]
59
1,474
12
3,833
835,210
Jangan asal mandi wajib! Beginilah tata caranyaโœจ A-thread
104
4,770
39
19,316
1,180,724
Canva is Awesome. But try this free tool, and you'll never use Canva again. Here's everything about this tool:
63
410
6
2,218
461,745
Forget ChatGPT, It costs $20/M to use. Here are 7 alternatives to you use GPT-4 for free. Open ๐Ÿงต
38
190
860
451,468
razinal retweeted
Key Concepts to Understand Database Sharding Database sharding refers to splitting data across multiple database servers and is commonly used for scaling. However, sharding introduces major operational and infrastructure complexity that should be avoided until absolutely necessary. Approaches to postpone sharding Vertical Scaling: Use more powerful single database servers - more CPUs, memory, storage and I/O bandwidth. Much simpler to manage than sharding while allowing sizable expansion. SQL Optimization: Tune SQL queries and database schema to maximize performance on a single server. Requires proper indexes, efficient SQL, etc. Caching: Use in-memory caches like Redis to reduce database load by avoiding hitting it for every common query. Read Replicas + Load Balancer: Adds horizontal read scaleability without full complexity of sharding. Directs reads across replicas. These optimization approaches should be exhausted before sharding given the complexity. Horizontal vs Vertical Sharding There are two high-level approaches: Vertical Sharding: Split database into columnar tables or sections vs rows. For example, having one table for names and another table for emails. Horizontal Sharding: Split database into row partitions distributed evenly across multiple servers. Some horizontal sharding methods: 1. Range Based: Segment rows based on range values like age groups. Can cause uneven data distribution and hot spots. 2. Directory Based: Use a lookup directory to locate rows. Allows flexibility but single point of failure risk. 3. Hash Based: Apply hash functions to spread rows uniformly across shards. Harder to rebalance. When sharding, use the simplest approach that meets requirements to minimize complexity. Seek to avoid until necessary. โ€“ Subscribe to our weekly newsletter to get a Free System Design PDF (158 pages): bit.ly/496keA7
8
333
4
1,532
166,762
Don't pay $20/ month for ChatGPT Plus. No Investment No Excuses Here are the 47 best plugins to become a Master & start making 2000/m
77
459
7
1,974
364,803
GPT-4 is a phenomenal AI tool in 2023. But it costs $20/month to use it. Here are 7 ways to access it for free:
83
645
31
2,562
766,790
๐—ง๐—ผ๐—ฝ ๐Ÿฎ๐Ÿฌ ๐—ฆ๐—ค๐—Ÿ ๐—พ๐˜‚๐—ฒ๐—ฟ๐˜† ๐—ผ๐—ฝ๐˜๐—ถ๐—บ๐—ถ๐˜‡๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐˜๐—ฒ๐—ฐ๐—ต๐—ป๐—ถ๐—พ๐˜‚๐—ฒ๐˜€ 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
69
1,634
36
8,057
984,499
GPT-4 is mind-blowing. But it costs $20/month to use it. Here are ways to access it for FREE:
27
80
1
257
155,894
NEW PROJECT! After 2 months of "silent" work, we present Filament Examples filamentexamples.com We've created 22 Filament projects (many more to come), addressing its features and questions from Twitter/Discord/YouTube. For 4 days only, 40% OFF! Coupon FILAMENTFOREVER
18
36
2
245
27,686
Here are my favorite 16 Laravel packages๐Ÿ“ฆ I would immediately DIE without them! ๐ŸงตKeep Reading
13
139
4
465
47,994
AI tools are the future. Switch to these free AI tools and save $100 a month!
78
1,206
12
3,769
361,834
This is the most advanced use of AI
44
201
18
885
194,832
This Google drive is a goldmine of resources on: โžก๏ธ Project Manag โžก๏ธ Product Manag โžก๏ธ Software Eng โžก๏ธScrum โžก๏ธPMP certification โžก๏ธSQL โžก๏ธUI/UX Design โžก๏ธ Interview Docs โžก๏ธ Data Analytics โžก๏ธ Business Analysis โžก๏ธData Visualization โžก๏ธBig Data drive.google.com/drive/mobilโ€ฆ SAVE & SHARE
52
1,334
24
2,811
463,279
Forget ChatGPT, It costs $20/M to use. Here are 7 alternatives to you use GPT-4 for free. Open ๐Ÿงต
31
160
4
508
217,011
No more need to pay $20 for ChatGPT Plus. Bing Chat has just received a massive update. Here's how to use its new features for free (even on mobile): [Thread]
69
319
14
1,583
759,035