As the proprietary vendors business models change, Linux video editing has increasing advantages, e.g. the lack of "subscription" business model. Avidemux is very powerful and actively developed.
If you have a Windows install and you buy Adobe Premiere Elements for $90, you will discover you must sign in, and Premiere Elements will max out your incoming internet connection for the entire time the program is open. But Premiere Elements works fine for video editing if you disable networking in control panel. So what's it doing with all that bandwidth?!
“the rudest word, the rudest letter is more good natured, more straightforward than silence. [...] I should not like to see rudeness undervalued; it is by far the most humane form of contradiction” — F.N.
The iron law of oligarchy is a political theory, first developed by the German sociologist Robert Michels in his 1911 book, Political Parties. It claims that rule by an elite, or oligarchy, is inevitable as an "iron law" within any democratic organization as part of the "tactical and technical necessities" of organization.
response from a core Git developer
on
Too Perfect a Mirror
·
· Score: 3, Informative
This is merely a new way to implement a ubiquitous and venerable concept: price discrimination.
There is hardly a thing in the world that some man can not make a little worse and sell a little cheaper.
gawker: The ever skeptical [Norman] Mailer knew more about what was going on than he let on, saying in 1964's The Presidential Papers that:
"At bottom, I mean profoundly at bottom, the FBI has nothing to do with Communism, it has nothing to do with catching criminals, it has nothing to do with the Mafia, the syndicate, it has nothing to do with trust-busting, it has nothing to do with interstate commerce, it has nothing to do with anything but serving as a church for the mediocre. A high church for the true mediocre."
Remember that famous Alan Holub piece from 2003?
Why extends is evil
Improve your code by replacing concrete base classes with interfaces
By Allen Holub, JavaWorld.com, 08/01/03
The technology in question reminds me of VTD-XML (Virtual Token Descriptor). Make an index that points into the document, "starting offset and length" as described here: VTD in 30 seconds. i4i's "map" is VTD's "index" + "location cache". But no one's talking about it.
Thank you for the link and your example code, that helped a lot. I want this to work, but I don't see enough performance improvement yet. Did I do this the way you imagined? I didn't try to finish the query on the full set because it took too long. Here I ran the join on 16 rows.
No GP wasn't me. MySQL 5.0.45 takes 10 mins 45 seconds on 2124 rows (vs. 0 mins 1.3 seconds for PostgreSQL 8.1.11). Slow enough? Also GP misstated: an int(10) unsigned isn't 10 bytes wide, it's 4 bytes wide.
Thank you for this interesting suggestion. I want it to work but I tried what you suggest and I don't see any difference in MySQL's query plan. I created exactly the same tables, except all columns of type int(10) unsigned converted to binary(4). The query plan is identical to the original.
The example setup is intended as a minimal demonstration, so I left out any keys on address.
I played a lot with where clauses, with no benefit. Anyway, shouldn't an industrial-strength RDBMS be able to interpret and optimize the simplest possible range join written as such?
I configured the strongest possible indices on range: 2 unique, 1 non-unique. Yes I tried FORCE INDEX, it made no difference (in execution time or EXPLAIN output).
My subject line sounds inflammatory yet see below for hard numbers and a simple, real example. Someone please show me how to coax MySQL to perform as well as PostgreSQL for this simple query (Postgres 496 times faster). It's been over two months since I posted this problem on two verypublic forums, with no response from the MySQL community. Would someone please stand up for MySQL and save it from looking weak here?!
I know the subject sounds inflammatory but I have hard numbers and a simple, yet realistic example. I would like it if someone would show me how to coax MySQL to perform as well as PostgreSQL for this simple query. It's been over two months since I posted this problem in two verypublic forums, with no response from the MySQL community. Would someone please stand up for MySQL and save it from looking weak here?!
MySQL join performance deficiency, 3 orders of mag
on
MySQL in a Nutshell
·
· Score: 2, Interesting
I know the subject sounds inflammatory but I have hard numbers and a simple, yet realistic example. I would like it if someone would show me how to coax MySQL to perform as well as PostgreSQL for this simple query. It's been over two months since I posted this problem in two verypublic forums, with no response from the MySQL community. Would someone please stand up for MySQL and save it from looking weak here?!
Slashdot Mirror
Political Hypocrisy: The Mask of Power, from Hobbes to Orwell and Beyond Paperback – August 1, 2010 by David Runciman, Cambridge political scientist.
As the proprietary vendors business models change, Linux video editing has increasing advantages, e.g. the lack of "subscription" business model. Avidemux is very powerful and actively developed.
If you have a Windows install and you buy Adobe Premiere Elements for $90, you will discover you must sign in, and Premiere Elements will max out your incoming internet connection for the entire time the program is open. But Premiere Elements works fine for video editing if you disable networking in control panel. So what's it doing with all that bandwidth?!
“the rudest word, the rudest letter is more good natured, more straightforward than silence. [...] I should not like to see rudeness undervalued; it is by far the most humane form of contradiction” — F.N.
The iron law of oligarchy is a political theory, first developed by the German sociologist Robert Michels in his 1911 book, Political Parties. It claims that rule by an elite, or oligarchy, is inevitable as an "iron law" within any democratic organization as part of the "tactical and technical necessities" of organization.
Jeff King at 2013-03-24 18:31:33 GMT
propagating repo corruption across clone
"So I think at the very least we should:
"
This is merely a new way to implement a ubiquitous and venerable concept: price discrimination. There is hardly a thing in the world that some man can not make a little worse and sell a little cheaper.
gawker: The ever skeptical [Norman] Mailer knew more about what was going on than he let on, saying in 1964's The Presidential Papers that: "At bottom, I mean profoundly at bottom, the FBI has nothing to do with Communism, it has nothing to do with catching criminals, it has nothing to do with the Mafia, the syndicate, it has nothing to do with trust-busting, it has nothing to do with interstate commerce, it has nothing to do with anything but serving as a church for the mediocre. A high church for the true mediocre."
Griftopia (2011) by Matt Taibbi.
Remember that famous Alan Holub piece from 2003? Why extends is evil
Improve your code by replacing concrete base classes with interfaces
By Allen Holub, JavaWorld.com, 08/01/03
There's a name for the pitfall risked by this strategy: overjustification effect.
The technology in question reminds me of VTD-XML (Virtual Token Descriptor). Make an index that points into the document, "starting offset and length" as described here: VTD in 30 seconds. i4i's "map" is VTD's "index" + "location cache". But no one's talking about it.
Thank you for the link and your example code, that helped a lot. I want this to work, but I don't see enough performance improvement yet. Did I do this the way you imagined? I didn't try to finish the query on the full set because it took too long. Here I ran the join on 16 rows.
mysql> create table `geomaddress` (`address` geometry NOT NULL, SPATIAL KEY `address` (`address`)) ENGINE=MyISAM select GeomFromText( concat( 'point(', address, ' 0)' ) ) as `address` from address;
Query OK, 2124 rows affected (0.08 sec)
mysql> CREATE TABLE `polyrange` (`poly` geometry NOT NULL, `id_country` tinyint(3) unsigned default NULL, SPATIAL KEY `poly` (`poly`), KEY `id_country` (`id_country`) ) ENGINE=MyISAM select GeomFromText( concat( 'polygon(( ', begin_num, ' 0, ', end_num, ' 0, ', begin_num, ' 0 ))' ) ) as `poly`, id_country from range;
Query OK, 105920 rows affected (24.07 sec)
mysql> create table `geoma2` (`address` geometry NOT NULL, SPATIAL KEY `address` (`address`)) ENGINE=MyISAM select address from geomaddress limit 16;
Query OK, 16 rows affected (0.00 sec)
mysql> select r.id_country from geoma2 a join polyrange r on MBRContains(r.poly,a.address);
16 rows in set (6.08 sec)
According to EXPLAIN MySQL isn't using the spatial index. It doesn't matter whether I use on or where.
mysql> explain select r.id_country from geoma2 a join polyrange r on MBRContains(r.poly,a.address)\G
*** 1. row ***
id: 1
select_type: SIMPLE
table: a
type: ALL
possible_keys: address
key: NULL
key_len: NULL
ref: NULL
rows: 16
Extra:
*** 2. row ***
id: 1
select_type: SIMPLE
table: r
type: ALL
possible_keys: poly
key: NULL
key_len: NULL
ref: NULL
rows: 105920
Extra: Range checked for each record (index map: 0x1)
2 rows in set (0.00 sec)
6.08 secs/16 = 0.38 secs/row. That would be 13 mins 22 seconds for 2124 rows. Can I do better?
The whole thing:
select range.id_country from address join range on address.address between range.begin_num and range.end_num
No GP wasn't me. MySQL 5.0.45 takes 10 mins 45 seconds on 2124 rows (vs. 0 mins 1.3 seconds for PostgreSQL 8.1.11). Slow enough? Also GP misstated: an int(10) unsigned isn't 10 bytes wide, it's 4 bytes wide.
Look here. People are talking.
Thank you for this interesting suggestion. I want it to work but I tried what you suggest and I don't see any difference in MySQL's query plan. I created exactly the same tables, except all columns of type int(10) unsigned converted to binary(4). The query plan is identical to the original.