StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSelect from database and limit with software, or limit on database (mysql)
text
Body
copied!<p>I am working on a social network platform which allows users to comment on posts.</p> <p>And I have came up with a dilemma that whether I should select all the comments for each post (when loading the page) and then use the software to cut it down, or should I limit the result using the mysql query.</p> <p>The reason for this dilemma is that, mysql does its own optimization and query/result caching, and if I limit the output, query caching will become useless(or maybe not?), but if I don't, I will have a software overhead, as well as getting more data than needed.</p> <p>The question may sound like this one <a href="https://stackoverflow.com/questions/2818571/mysql-and-the-limit-clause/">MYSQL and the LIMIT clause</a> which refers to limit 1, but in my case, the number of results can be from 0 to 3000 (or even more). The limit is usually 3, but will be different if users want to see more comments.</p> <p>I should mention that the query does have an ORDER BY id DESC clause and its a SELECT * (it must be). Basically, SELECT * FROM table WHERE postid='$variable' ORDER BY id DESC.</p> <p>I also have to mention that the software has been running fine for over 2 years, but I'm in the process of optimizing it. So, any help would be great.</p> <p>EDIT: <strong>TL;DR</strong> The main question is this: Is having one database query and then using software to use part of it better than requesting the exact data needed (with limit clause) ?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload