Queries Memes

Posts tagged with Queries

We Will Process Only Last 1000 Files They Said

php Algorithms Programming Databases Backend

22 days ago 194.6K views 0 shares

We Will Process Only Last 1000 Files They Said

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.

Select Data Science From SQL

Databases AI Programming

6 months ago 230.5K views 1 shares

Select Data Science From SQL

Ah yes, the classic executive who just discovered the term "data science" and now thinks anyone who can run a basic SQL query is suddenly a data scientist. Nothing says "I understand tech" quite like watching someone execute SELECT * FROM table and immediately asking if they should update their LinkedIn to "Senior ML Engineer." Meanwhile, actual data scientists with PhDs in statistics are quietly crying into their Jupyter notebooks.