Follow Slashdot blog updates by subscribing to our blog RSS feed

 



Forgot your password?
typodupeerror

Comment avidemux (Score 3, Interesting) 223

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?!

Comment Robert Michels, 1911, iron law of oligarchy (Score 1) 818

From wikipedia:

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.

Comment of the FBI, Norman Mailer said (Score 1) 573

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."

Comment Re:MySQL join performance deficiency, 2 orders of (Score 1) 155

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?

Slashdot Top Deals

"Consistency requires you to be as ignorant today as you were a year ago." -- Bernard Berenson

Working...