Hacker News new | past | comments | ask | show | jobs | submit login

He's not selecting each row one-by-one.

Yes he does: "even if we did it in this naive way, the total execution time is still a very reasonable".

He's getting 48 records back using two queries.

This is equally silly. The two queries would be equivalent to the single one if there weren't two round trips instead of one, more traffic (the ids are retrieved twice instead of once and they are also sent to the server) and the overhead from concatenating and then parsing all the ids in the second query.




I concede. Got confused with the original posts wording, thanks for clearing it up!




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: