On Mon, 2003-03-03 at 23:20, Russell Hires wrote:
> Not to start a religious war, but there's also PostgreSQL. It has front ends
> that will run from both Windows and from Linux (though they are different
> programs). They both ultimately connect to the back end server.
http://www.illusionary.com/snort_db.html
Some interesting results from looking at MySQL and PostgreSQL
performance. I have further numbers (not yet documented anywhere) that
show PostgreSQL outperforming MySQL almost across the board on anything
more than a simple "SELECT * FROM" query, and getting further and
further apart the more records you get in the database. (i.e. MySQL
performance degrades faster than PostgreSQL performance with increasing
numbers of records in the db.)
So I would almost certainly pick PostgreSQL, if only because it's more
SQL-compliant than MySQL and still has the performance.
FWIW - I also have tested against Oracle 9i on Linux, which, while
horribly slow when doing straight INSERTs, soundly beats both of them on
SELECT speed and the curve of "query speed versus number of records" is
virtually linear. I stand by my claims that Oracle is truly one of the
few applications you can buy that is worth what you pay for it because
of things like that.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
#!/usr/bin/perl -w
$_='while(read+STDIN,$_,2048){$a=29;$b=73;$c=142;$t=255;@t=map
{$_%16or$t^=$c^=($m=(11,10,116,100,11,122,20,100)[$_/16%8])&110;
$t^=(72,@z=(64,72,$a^=12*($_%16-2?0:$m&17)),$b^=$_%64?12:0,@z)
[$_%8]}(16..271);if((@a=unx"C*",$_)[20]&48){$h=5;$_=unxb24,join
"",@b=map{xB8,unxb8,chr($_^$a[--$h+84])}@ARGV;s/...$/1$&/;$d=
unxV,xb25,$_;$e=256|(ord$b[4])<<9|ord$b[3];$d=$d>>8^($f=$t&($d
>>12^$d>>4^$d^$d/8))<<17,$e=$e>>8^($t&($g=($q=$e>>14&7^$e)^$q*
8^$q<<6))<<9,$_=$t[$_]^(($h>>=8)+=$f+(~$g&$t))for@a[128..$#a]}
print+x"C*",@a}';s/x/pack+/g;eval
usage: qrpff 153 2 8 105 225 < /mnt/dvd/VOB_FILENAME \
| extract_mpeg2 | mpeg2dec -
http://www.cs.cmu.edu/~dst/DeCSS/Gallery/
http://www.eff.org/ http://www.anti-dmca.org/
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:30:58 EDT