The question now is, if everything will be as before for you, why do you care if others get it for free? Is this some "justice" thing?
The thing that determines how much work the database has to do in order to produce the results is the FROM, the WHERE and the GROUP BY, because those are the ones that determine what's going to be accessed, joined, sorted and how. The SELECT (except for the use of aggregate functions) primarily just decides what information to present from the join results and how to present it.
I don't think this is correct. The SELECT list does impact the performance of the query because if it requires un-indexed columns that are not used any other clause(WHERE, FROM) than a lookup or a table scan will be needed to retrieve the values.
This being said the only way that removing a column form the select list of a query will make it slower is if the query planner has some bugs
you get out, nothing gets in
Can someone explain this? I was under the impression that having an IPv6 address is exactly like having a public IPv4 address now (if your software can handle it). That is everyone can get in/out and you can easily host your own server and stuff..
, its not huge, but enough to notice when playing fast paced games
You need to have your head examined.
At 60 FPS, a frame is 16.7 ms long. I.E. adding 7ms to your input latency doesn't even show up on the screen.
Most people in the UK are happy to be profiled in exchange for financial benefits. When the Tesco Clubcard was introduced it was so popular that people stopped shopping at other supermarkets like Sainsburys, which then had to introduce their own "loyalty card" schemes. Tesco announced last year that there are now 16 million active clubcards in the UK. As a comparison point there are around 25 million households in the UK , so a significant number of British households are having their shopping profiled in detail already.
Almost anything derogatory you could say about today's software design would be accurate. -- K.E. Iverson