Thanks for the info, but i actually speak from experience and not everything is centered around Web hosting.
I use MySQL with InnoDB to collect and analyze process data. With that it is important to have a constant insert rate
yet at the same time still allow for deep and complex queries. This is where i had problems with Pg, i used the same schema
and queries, but after some time (about 4-5 weeks) Pg's query performance steadily degraded until it was almost unusable.
I checked my queries and made sure everything was indexed correctly and the indexes where actually used and
after a restart it worked again acceptably for another week or so, but then it was unacceptably slow again.
I also had some really weird problems, like a query with a "Time BETWEEN 'xxx' AND 'yyy'" taking 2+ minutes
(should be < 3 sec) but then if just using "Time > 'xxx'" it worked in a few seconds even though it returned a lot more data.
In any case, i don't trust some benchmarks, i try it out and see how it works for my application
and if i can't make it work acceptably in a sensible amount of time then either the DBMS is too complicated to configure 'right'
or it just isn't suited for what i'm doing.
For me, as a developer that has used MySQL for some time, this is an action that destroys trust.
They say it is to keep too many versions of MySQL from being used, a lie that is so obvious
it would have been better if they hadn't said anything at all.
This, of course, isn't the first time i have begone to wonder about the ethics of the MySQL team,
the first was when they recreated their website, hiding the 'download' section in the 'comunity' section
and even then only after making you click a 'yes i'm a total über geek, i recompile my kernel every DAY!' button.
To me that means that i can no longer trust MySQL, i can no longer trust them to not sink to even lower tactics
to get us away from using MySQL under the GPL. Now i have to fear that they not only will they withhold features as
they already do, but that they will also intentionally introduce bugs and cripple performance just so they can then state
'well, with our NON-GPL commercial Enterprise license, that wouldn't have happened'
I liked MySQL because it was quick to setup and had reliable and scalable performance, i might be able to get
similar performance etc with PostgreSQL, but it will definitely not be simple to do simple things and it requires constant tweaking and probably the blood of sacrificially slain goat to work reliable performance wise.
Now i might even consider using the 'light' (free) version of SQL Server and Oracle, even with thier limitations,
for many projects they are enough, and for those that aren't, i now at least don't have to explain
how and why MySQL is a 'real' database engine, i can simply say,
'sure, oracle, i can do that, it will cost lot's more, but yea'
Is there hope that some one will take the source as it's now and create a new GPL branch without the
commercial BS?
The reason this is wrong is becuase they know full well that TPB never had any child porn and never will!
It's not about downloading copyrighted works either, it's only about payback for not being able to find any evidence
of any wrong doing and the embarrassments this has caused them.
Of course this was done with the 'help' of the BSA, MPAA and RIAA, i'm just waiting for them to
brag how thier 'influence' has 'saved the world' (and the children, of course) again.
This even goes beyond just despicable corruption and right into treason,
forsaking their own laws and people for some foreign cooperate payoff.
Well time to mail: childabuse@rkp.police.se and tell them
how little we like corrupt, treasonous, scumm of the earth police abusing their power.:)
Information about the draft law and what people can do to prevent it from being passed can be found at the following site: http://www.vorratsdatenspeicherung.de/ (also in German)
What's scary is the range of people that are supposed to get access to the collected information,
it's not just the police but also "Nachrichtendienste" (news agencies!?) and "ausländische Staaten" (other countries, apparently any that ask)
I'm guessing this is caused by some lobby/bribe action of organizations like the RIAA/MPAA.
I can't think of one good reason of why this might be good for anyone,
criminals will just use bot proxies or other means to bypass the tracking/collection and in the end
it will just be the honest people that get f#cked because with general government incompetence
the the data will end up in the criminal's hand's and used for who knows what.
Well as stated before, you can't just parallelize any task, if you could then compilers would have done it for the programmers long ago.
It's also pointless to parallelize any task depending directly on a limited shared resource, for example copying files from A to B isn't going to get any faster when you copy 3 files at once, it will in fact be slower (since the hard drive has to jump back in forth, NCQ might help, but it's still less then 100%).
What i hear people bitch most about are Games. Games are not as easy to parallelize as some might think because some of the 'tasks' involved cannot be parallelized and those that can are usually tied by a together by a shared resources (i.e. graphics card, geometry, textures). For example, you can try to do do the geometry transformation parallelized and separate from a rendering thread, but when writing the transformed geometry back to, for example, the vertex buffer you have to lock that buffer, meaning any thread trying to read/write from it has to wait for the operation to complete. If each thread tried just tried to access the shared resource whenever they have finished, they may end up waiting a long time for another threads (such as the the rendering thread for example), or block other threads trying to access the same resource. If you have threads waiting on other threads most of the time then you already have removed most of the the parallel execution benefits, in fact, the threading overhead may be worse then benefit gained from parallel execution in the first place. Another thing is that even if most of the 'tasks' in a game have been parallelized, you still only see the 'weakest' link. For example, if you have a Geforce 2 GTS running the latest Unreal 3 Engine (if that where possible) then it won't matter that you have a 16 Core CPU and the game is parallelized every possible task. You still get crappy FPS. An usually the weakest link (task) is one that cannot be parallelized.
I wonder how long before AMD makes a PC-on-a-chip, like VIA did.
Now with ATI they should have all the required components for that (good graphics controller etc).
I didn't use or even installed ICQ for at least 5 years
but wanted to check if my really old account with a nice 7 digit account number was still active.
Used: http://go.icq.com/ (no installation needed) to check.. and it is still working, guess i got lucky.
Now for another 5 years of not using it (but of course wanting to keep it:)
Sorry, i forgot to mention that this is with a 'flatrate', and it's only illegal to store info. that isn't required for the service being provided.
So with the flatrate, storing bandwidth without consent is illegal, with a metered service it probably isn't.
And yes, i will try to do a better job at spelling from now on;)
Also, i pay around 55 Euro for this service so it's not really cheap (20E of that is for the required phone connection)
I have been living in Germany for over a year an have signed up to T-com's 16Mbit/s Service, since then i have been downloading about 5-15GB a day.
No nasty letters yet, but if they do come, i'll have to remind them that storing personal information such as the amount of bandwidth consumed is illegal in German:
http://www.daten-speicherung.de/index.php/datenspe icherung/musterklage-ip-speicherung/
Slashdot Mirror
Thanks for the info, but i actually speak from experience and not everything is centered around Web hosting.
I use MySQL with InnoDB to collect and analyze process data. With that it is important to have a constant insert rate
yet at the same time still allow for deep and complex queries. This is where i had problems with Pg, i used the same schema
and queries, but after some time (about 4-5 weeks) Pg's query performance steadily degraded until it was almost unusable.
I checked my queries and made sure everything was indexed correctly and the indexes where actually used and
after a restart it worked again acceptably for another week or so, but then it was unacceptably slow again.
I also had some really weird problems, like a query with a "Time BETWEEN 'xxx' AND 'yyy'" taking 2+ minutes
(should be < 3 sec) but then if just using "Time > 'xxx'" it worked in a few seconds even though it returned a lot more data.
In any case, i don't trust some benchmarks, i try it out and see how it works for my application
and if i can't make it work acceptably in a sensible amount of time then either the DBMS is too complicated to configure 'right'
or it just isn't suited for what i'm doing.
For me, as a developer that has used MySQL for some time, this is an action that destroys trust.
They say it is to keep too many versions of MySQL from being used, a lie that is so obvious
it would have been better if they hadn't said anything at all.
This, of course, isn't the first time i have begone to wonder about the ethics of the MySQL team,
the first was when they recreated their website, hiding the 'download' section in the 'comunity' section
and even then only after making you click a 'yes i'm a total über geek, i recompile my kernel every DAY!' button.
To me that means that i can no longer trust MySQL, i can no longer trust them to not sink to even lower tactics
to get us away from using MySQL under the GPL. Now i have to fear that they not only will they withhold features as
they already do, but that they will also intentionally introduce bugs and cripple performance just so they can then state
'well, with our NON-GPL commercial Enterprise license, that wouldn't have happened'
I liked MySQL because it was quick to setup and had reliable and scalable performance, i might be able to get
similar performance etc with PostgreSQL, but it will definitely not be simple to do simple things and
it requires constant tweaking and probably the blood of sacrificially slain goat to work reliable performance wise.
Now i might even consider using the 'light' (free) version of SQL Server and Oracle, even with thier limitations,
for many projects they are enough, and for those that aren't, i now at least don't have to explain
how and why MySQL is a 'real' database engine, i can simply say,
'sure, oracle, i can do that, it will cost lot's more, but yea'
Is there hope that some one will take the source as it's now and create a new GPL branch without the
commercial BS?
The reason this is wrong is becuase they know full well that TPB never had any child porn and never will!
:)
It's not about downloading copyrighted works either, it's only about payback for not being able to find any evidence
of any wrong doing and the embarrassments this has caused them.
Of course this was done with the 'help' of the BSA, MPAA and RIAA, i'm just waiting for them to
brag how thier 'influence' has 'saved the world' (and the children, of course) again.
This even goes beyond just despicable corruption and right into treason,
forsaking their own laws and people for some foreign cooperate payoff.
Well time to mail: childabuse@rkp.police.se and tell them
how little we like corrupt, treasonous, scumm of the earth police abusing their power.
Ah, that makes a lot more sense. Thanks!
Here the original Spiegel Article(in German, of course).
Information about the draft law and what people can do to prevent it from being passed can be found at the following site:
http://www.vorratsdatenspeicherung.de/ (also in German)
What's scary is the range of people that are supposed to get access to the collected information,
it's not just the police but also "Nachrichtendienste" (news agencies!?) and "ausländische Staaten" (other countries, apparently any that ask)
I'm guessing this is caused by some lobby/bribe action of organizations like the RIAA/MPAA.
I can't think of one good reason of why this might be good for anyone,
criminals will just use bot proxies or other means to bypass the tracking/collection and in the end
it will just be the honest people that get f#cked because with general government incompetence
the the data will end up in the criminal's hand's and used for who knows what.
GIMP
and
CMYK support for The GIMP
Well as stated before, you can't just parallelize any task, if you could then compilers would have done it for the programmers long ago.
It's also pointless to parallelize any task depending directly on a limited shared resource, for example copying files from A to B isn't going to get any faster when you copy 3 files at once, it will in fact be slower (since the hard drive has to jump back in forth, NCQ might help, but it's still less then 100%).
What i hear people bitch most about are Games. Games are not as easy to parallelize as some might think because some of the 'tasks' involved cannot be parallelized and those that can are usually tied by a together by a shared resources (i.e. graphics card, geometry, textures). For example, you can try to do do the geometry transformation parallelized and separate from a rendering thread, but when writing the transformed geometry back to, for example, the vertex buffer you have to lock that buffer, meaning any thread trying to read/write from it has to wait for the operation to complete. If each thread tried just tried to access the shared resource whenever they have finished, they may end up waiting a long time for another threads (such as the the rendering thread for example), or block other threads trying to access the same resource. If you have threads waiting on other threads most of the time then you already have removed most of the the parallel execution benefits, in fact, the threading overhead may be worse then benefit gained from parallel execution in the first place.
Another thing is that even if most of the 'tasks' in a game have been parallelized, you still only see the 'weakest' link. For example, if you have a Geforce 2 GTS running the latest Unreal 3 Engine (if that where possible) then it won't matter that you have a 16 Core CPU and the game is parallelized every possible task. You still get crappy FPS. An usually the weakest link (task) is one that cannot be parallelized.
I wonder how long before AMD makes a PC-on-a-chip, like VIA did.
Now with ATI they should have all the required components for that (good graphics controller etc).
I am thinking ultra ultra portable =)
I didn't use or even installed ICQ for at least 5 years :)
but wanted to check if my really old account with a nice 7 digit account number was still active.
Used: http://go.icq.com/ (no installation needed) to check.. and it is still working, guess i got lucky.
Now for another 5 years of not using it (but of course wanting to keep it
Sorry, i forgot to mention that this is with a 'flatrate', and it's only illegal to store info. that isn't required for the service being provided. So with the flatrate, storing bandwidth without consent is illegal, with a metered service it probably isn't. And yes, i will try to do a better job at spelling from now on ;)
Also, i pay around 55 Euro for this service so it's not really cheap (20E of that is for the required phone connection)
I have been living in Germany for over a year an have signed up to T-com's 16Mbit/s Service, since then i have been downloading about 5-15GB a day. No nasty letters yet, but if they do come, i'll have to remind them that storing personal information such as the amount of bandwidth consumed is illegal in German: http://www.daten-speicherung.de/index.php/datenspe icherung/musterklage-ip-speicherung/