SELECT id, title FROM page WHERE id IN (SELECT pageid FROM hotnews WHERE user = 8)
The answer to this is to execute the sub query and pass the result back as an array. If you have 10,000 records in table page, you will see about a 2000x speed improvement if you are using php
If you create a query in mysql with an IN statement in the where clause and you put a sub query as the in statement current versions will run the query once for each row of the primary table you are querying. Caching result alone would probably get the 70x speed up. I am suspect that there are other performance stupidities in mysql that are worked around by people doing a simple query and then using php/perl/python/java/etc to parse the result and generate the second query.
The posters questions have been answered with links, but really it was a slashdot post and the studies were very widely reported.
I will admit I was a bit inflammatory as the authors of the studies recommended the cover up campaign continue but that people should also be told to consume vitamin D supplements. But, the lack of knowledge of the fact that vitamin D deficiency is more wide spread than skin cancer in Australia is a little surprising. (Admittedly skin cancer is a scarier because successful treatment is far less certain than things like osteoporosis, and such)
The scary thing is that the scientific studies that are peer reviewed about gmo's is shockingly close to zero.
Some of the gmo's are possibly a lot better for you and some are possibly as bad as the grand parent post claims, and the industry doesn't seem to want to know, which leads to some uncomfortable thoughts about the safety of our food supply and monocrops that are enabled by gmo's.
Did you know that if a five digit PLU code starts with the number 8 it is GMO, but nobody uses that code, the idea was that maybe GMO foods would be higher in vitamins or have some other positive value and be worth more to consumers. The reality is that food industry believes that if it was easy to tell if food was GMO it would not sell except at very steep discount. Sort of like Chinese peppers are about 1/5 the price of peppers grown in Chile in the San Francisco area (at least at the stores I shop at.)
The food industry's behavior around GMO food is similar enough to how the tobacco industry behaved that people are very suspicious of GMO foods.
If the food industry was willing to have clear labels on all GMO food maybe there would be some studies that would allow us to say what GMO food is and isn't fit for human consumption. Some of it is probably fine, some of it probably not so.
Although debian/ubuntu generated keys could be living on RHEL/FreeBSD/SuSE machines that might not be checking for the bad keys. Considering at one point I would guessestimate 8% of keys or so were bad (based on debian and children market share) The debian disaster could still have some overhead.
But, you're right that 0.2% seems a little high for the overhang.
The only app that runs is the browser, it is based on gentoo so you can install pam modules to meet your site requirements needs (ldap, kerberos, etc),
And it is designed so you can easily force an enterprise wide os refresh whenever you need/want.
What's next? Banning windows and outdoor recess? Both of those activities subject students to far greater EMF Radiation from the fusion reaction commonly referred to as "the sun" Further more "Cover up" campaigns in Australia aimed at lowering skin cancer rates showed an increase in vitamin D related conditions that far outweighed any health benefits from the campaign.
This is all over the fact that the cancer rates around high voltage power lines in Colorado in the late 60s and early 70s were far above what would be expected. The moral of that was that maybe you should check if the power company is using agent orange for weed control (they were) before you look like an ass, and create a bunch of junk science about the dangers of EMF radiation.
There have been hundreds of studies about EMF and none of the studies without major flaws have shown any correlation between EMF radiation and cancer, or any other disease.
In the 70s and 80s your comments made sense, now it just makes you look stupid and causes people to be dismissive of your overall agenda, which would be good, if you were not chasing something that people instinctively know is wrong.
Interestingly pro athletes and entertainers are unionized.
Dockworkers in Oakland CA typically make in the low six figures, but that is also a very unionized environment.
The dock workers struck a few years ago because they were being replaced by computer techs that were non-union and getting about a third of what the union workers were (the result of the strike is that the computer professionals at the port are now union scale.
My estimates are that first past the post are mostly partisan contests (in the US). Most non-partisan races are true run off elections that tend to produce drastically different results than first past the post.
It's on the roadmap, the last I looked at the issue they were looking at a replacement for the java odbc connector. which is the main java dependency as I recall.
Libreoffice on FreeBSD compiles more reliably without the java dependency..
Java is used primarily for the database connector, so you lose the database functionality.
While the java dependency removal is on the road map. What to do about the advanced mail merge and wiki extensions that also depend on java is not yet clear (probably in the open source tradition, just drop support after a warning for one version about java support being deprecated.)
Although polls show that that most Americans want socialism, they just don't want it called that. "Down with socialism, save medicare" is the cry of many Americans. Don't ask me how you explain to them that medicare is socialism.
Your comments about varnish and nginx don't match my experiences.
I have that the recent versions of varnish are faster on linux, with nginx being too close to call.
When varnish was just getting noticed you were probably right, but a lot of people with lots of motivation to get varnish working well on linux have added patches to varnish that have sort of reversed that in my experience, not that most people are going to bump heads with what varnish can handle.
The nice/evil thing about varnish's config file is that it is in C and compiled before being loaded. It is a fun system to play with/setup.
Start with a list of common passphrases. (they exists just like password dictionaries.)
Try the phrases from a book of famous quotes. (The "random" phrase that is easy to remember is more likely to be chosen).
Do a search for a few common phrase generators, which typically have
Realize that common words > 6 characters are a pretty small list, and generate a dictionary of all of the 6 plus character words from the scrabble dictionaries as 2,3 and 4 word phrases.
See what percentage of passphrases have fallen.
Go to lunch and come back for the afternoon attempts.
The problem with passwords and passphrases is that people have to implement them, and, for the most part, we implement them the same few ways.
Unfortunately, it turns out that the ordering of phrases and the parts of speech tend to pull the entropy of pass phrases into the general range of dictionary words.
Personally I have gone to passkeys stored on usb devices for anything that really matters, but fortunately there is very little that I am responsible for securing that really matters.
I moved most of my linodes from freemont (he.net) to dallas over those instances.
From what I could understand HE.net had some bad UPSes that they were sold and replaced them with ones from another vendor.
Overall, the disk access thoughput has been pretty good, network connectivity OK.
One thing is that the "private network is not really private, and you don't get real private network connecting your vms.
The price is about $80 a month for 2GB of ram, which seems to be about the going rate.
The HE.net disaster could have been handled a little better, but once I found out that it was a problem with HE.net I found HE.net's reporting of the disaster pretty good, With ETA's and live status feeds, which if you are reselling or managing the server professionally makes it seem like you are on top of the situation.
WTF? fluxbox over featured? There are not many window managers that have noticeably fewer features, windows 3.0, and twm, although I think that the config file of twm actually has more features, IIRC bash 3 uses more memory than any of the *box window managers.
Slashdot Mirror
SELECT id, title FROM page WHERE id IN (SELECT pageid FROM hotnews WHERE user = 8)
The answer to this is to execute the sub query and pass the result back as an array. If you have 10,000 records in table page, you will see about a 2000x speed improvement if you are using php
If you create a query in mysql with an IN statement in the where clause and you put a sub query as the in statement current versions will run the query once for each row of the primary table you are querying. Caching result alone would probably get the 70x speed up. I am suspect that there are other performance stupidities in mysql that are worked around by people doing a simple query and then using php/perl/python/java/etc to parse the result and generate the second query.
The posters questions have been answered with links, but really it was a slashdot post and the studies were very widely reported.
I will admit I was a bit inflammatory as the authors of the studies recommended the cover up campaign continue but that people should also be told to consume vitamin D supplements. But, the lack of knowledge of the fact that vitamin D deficiency is more wide spread than skin cancer in Australia is a little surprising. (Admittedly skin cancer is a scarier because successful treatment is far less certain than things like osteoporosis, and such)
http://www.theage.com.au/articles/2007/12/08/1196813083745.html is a quick link that references studies that showed in the early 2000's very roughly 25% of Austrailians had issues due to depressed vitamin D.
This was blamed almost entirely on the cover-up campaign. Further (and not mentioned in the article) the skin cancer rates barely budged.
Having someone use agent orange in your back yard is a bigger risk to getting cancer though.(WTF were they thinking?)
Go to this link and look at the Vitamin D deficiency studies in Australia. (the first one is the second search result)
There are a lot of studies backing up what I said. It was big news that the cover up campaign was making people worse not better.
The scary thing is that the scientific studies that are peer reviewed about gmo's is shockingly close to zero.
Some of the gmo's are possibly a lot better for you and some are possibly as bad as the grand parent post claims, and the industry doesn't seem to want to know, which leads to some uncomfortable thoughts about the safety of our food supply and monocrops that are enabled by gmo's.
Did you know that if a five digit PLU code starts with the number 8 it is GMO, but nobody uses that code, the idea was that maybe GMO foods would be higher in vitamins or have some other positive value and be worth more to consumers. The reality is that food industry believes that if it was easy to tell if food was GMO it would not sell except at very steep discount. Sort of like Chinese peppers are about 1/5 the price of peppers grown in Chile in the San Francisco area (at least at the stores I shop at.)
The food industry's behavior around GMO food is similar enough to how the tobacco industry behaved that people are very suspicious of GMO foods.
If the food industry was willing to have clear labels on all GMO food maybe there would be some studies that would allow us to say what GMO food is and isn't fit for human consumption. Some of it is probably fine, some of it probably not so.
Although debian/ubuntu generated keys could be living on RHEL/FreeBSD/SuSE machines that might not be checking for the bad keys. Considering at one point I would guessestimate 8% of keys or so were bad (based on debian and children market share) The debian disaster could still have some overhead.
But, you're right that 0.2% seems a little high for the overhang.
http://www.chromium.org/chromium-os
The only app that runs is the browser, it is based on gentoo so you can install pam modules to meet your site requirements needs (ldap, kerberos, etc),
And it is designed so you can easily force an enterprise wide os refresh whenever you need/want.
What's next? Banning windows and outdoor recess? Both of those activities subject students to far greater EMF Radiation from the fusion reaction commonly referred to as "the sun" Further more "Cover up" campaigns in Australia aimed at lowering skin cancer rates showed an increase in vitamin D related conditions that far outweighed any health benefits from the campaign.
This is all over the fact that the cancer rates around high voltage power lines in Colorado in the late 60s and early 70s were far above what would be expected. The moral of that was that maybe you should check if the power company is using agent orange for weed control (they were) before you look like an ass, and create a bunch of junk science about the dangers of EMF radiation.
There have been hundreds of studies about EMF and none of the studies without major flaws have shown any correlation between EMF radiation and cancer, or any other disease.
In the 70s and 80s your comments made sense, now it just makes you look stupid and causes people to be dismissive of your overall agenda, which would be good, if you were not chasing something that people instinctively know is wrong.
Less so since projects like samba have moved to the GPL 3 with its anti patent troll clause.
Apple is very pro patent troll. If it hurts their customers, whatever.
Interestingly pro athletes and entertainers are unionized.
Dockworkers in Oakland CA typically make in the low six figures, but that is also a very unionized environment.
The dock workers struck a few years ago because they were being replaced by computer techs that were non-union and getting about a third of what the union workers were (the result of the strike is that the computer professionals at the port are now union scale.
Something to think about anyways.
My estimates are that first past the post are mostly partisan contests (in the US). Most non-partisan races are true run off elections that tend to produce drastically different results than first past the post.
It's on the roadmap, the last I looked at the issue they were looking at a replacement for the java odbc connector. which is the main java dependency as I recall.
The dot com days were pretty fun and exciting. (and I am showing my age.)
Running tidy is the first step for such sites.
Libreoffice on FreeBSD compiles more reliably without the java dependency..
Java is used primarily for the database connector, so you lose the database functionality.
While the java dependency removal is on the road map. What to do about the advanced mail merge and wiki extensions that also depend on java is not yet clear (probably in the open source tradition, just drop support after a warning for one version about java support being deprecated.)
Although polls show that that most Americans want socialism, they just don't want it called that. "Down with socialism, save medicare" is the cry of many Americans. Don't ask me how you explain to them that medicare is socialism.
Your comments about varnish and nginx don't match my experiences.
I have that the recent versions of varnish are faster on linux, with nginx being too close to call.
When varnish was just getting noticed you were probably right, but a lot of people with lots of motivation to get varnish working well on linux have added patches to varnish that have sort of reversed that in my experience, not that most people are going to bump heads with what varnish can handle.
The nice/evil thing about varnish's config file is that it is in C and compiled before being loaded. It is a fun system to play with/setup.
In my somewhat limited experience the place that nginx really shines is ssl.
I am prone to putting varnish on 80 and nginx on 443 with something heavy on the back end to spit out the dynamic content to the reverse proxies,
The problem with passwords and passphrases is that people have to implement them, and, for the most part, we implement them the same few ways.
Unfortunately, it turns out that the ordering of phrases and the parts of speech tend to pull the entropy of pass phrases into the general range of dictionary words.
Personally I have gone to passkeys stored on usb devices for anything that really matters, but fortunately there is very little that I am responsible for securing that really matters.
I moved most of my linodes from freemont (he.net) to dallas over those instances.
From what I could understand HE.net had some bad UPSes that they were sold and replaced them with ones from another vendor.
Overall, the disk access thoughput has been pretty good, network connectivity OK.
One thing is that the "private network is not really private, and you don't get real private network connecting your vms.
The price is about $80 a month for 2GB of ram, which seems to be about the going rate.
The HE.net disaster could have been handled a little better, but once I found out that it was a problem with HE.net I found HE.net's reporting of the disaster pretty good, With ETA's and live status feeds, which if you are reselling or managing the server professionally makes it seem like you are on top of the situation.
Well blackbox is half the size of openbox and still has a status bar :)
WTF? fluxbox over featured? There are not many window managers that have noticeably fewer features, windows 3.0, and twm, although I think that the config file of twm actually has more features, IIRC bash 3 uses more memory than any of the *box window managers.