Poorly Optimized SQL: The Empty Promise

When your manager says "just process the last 1000 files" but you're dealing with a PHP script that's about to iterate through 2 million files while comparing against a database of 1 million records. The script is literally pulling 1000 records with limit(1000) but then checking EACH of your 2 million files against those 1000 records with in_array() . That's a cool O(n²) operation that's going to take approximately checks notes forever to complete. Your server's CPU is already writing its resignation letter.

Content DON'T ALWAYS TYPE IN ALL CAPS, BUT WHEN I DO, I'M PROBABLY WRITING A SOL QUERY imeflip.com

Content A CRYPTO NERDS IMAGINATION: HIS LAPTOP'S ENCRYPTED. LET'S BUILD A MILLION-DOLLAR CLUSTER TO CRACK IT. NO GOOD! IT'S 4096 -BIT RSA! BLAST! OUR EVIL PLAN 15 FOILED! WHAT WOULD ACTUALLY HAPPEN: HIS LAPTOP'S ENCRYPTED. DRUG HIM AND HIT HIM WITH THIS 5 WRENCH UNTIL HE TELLS US THE PASSWORD. GOT IT.

Content Andy Ryan ltsAndyRyan Me: I'm an expert at identifying birds Her: OK, what about those ones flying over that tree? Me: Yup, they're all birds 8:43 AM Nov 22, 2018 Twitter Web Client

Content Net Developer Centric Consulting Apply On Company Site Do you have a passion for JAVA? Centric Consulting is looking to hire a NET Developer for one of our key clients. Our client is looking for a seasoned professional to make an impact on their team and personal career. This is a mid-level full time remote employment opportunity with our client. What You'll Do as a .NET Developer Build new features and write all kinds of automated tests for them (AngularJS 2 and REST services in WebAPI). Maintain existing features (ASP.NET MVC 5). Keep builds green (TeamCity) and deploy releases (Octopus Deploy). Help write scripts (mainly Powershell) if you enjoy automating processes. Come up with ideas. Learn, refactor, improve. Work in an Agile Kanban way in a remote team. What You'll Bring We want someone who likes to solve problems. You should enjoy taking on the hard stuff. Excellent communication skills are important - both written and verbal. Last but not least, you will, of course, need to be a solid Net Developer. We are looking for people with demonstrated capabilities with Net. The more experience you have with technologies and languages such as C, NET 4.5, WebAPI, ASP NET MVC 5, AngularJS 2, TypeScript, SQL, Entity Framework, the better. Centric believes the best solutions come from diverse teams. We strive to have an environment where everyone has an opportunity to be successful regardiess of their race, color, religion, gender, national origin, ancestry, age, disability, military or veteran status, sexual orientation or gender identity Centric Consulting - 30 days ago - save job - original job

Content chadchampion 7h 5) 1 Award Not super dark, but I never graduated high school. Noone knows. 5 Reply 2.7k J BillyFromAccounting 4h There is only way to see if OP is legit. What is 2 2? 4 786 bigblackcoconut420 4h 3 2 Awards 22 adds to double 2 and double 2 is 22 4 1.1k J ResponseProper 3h Slow down for the re... LordGeneralTimmy 3h Found the JavaScript dev 4 19 u