Re: ready for some testing

On Nov 27, 2003, at 11:50, Russell Valentine wrote:

>> Out of curiousity, did you every play with Anthill using mysql?  I'm
>> curious on your thoughts as to wether you think the postgres backend 
>> is
>> faster.  It seems faster to me, but I can't bench it properly yet
>> because my Linux laptop (AMD 2400+XP with 512MB RAM) is running
>> postgres whereas my OS X laptop (1GHz with 1GB RAM) is using MySQL..
>> but the postgres one seems faster to me.
>
> I'm sorry I havn't, I just tried the demo before PostgreSQL support was
> added. I've always been impressed with PostgreSQL performance and 
> feature
> set. Where I work I have databases that have several gigs of data and
> tables with many millions of rows and once I optimized the queries and
> added indexes it works fast and great! Basicly I choose PostgreSQL for 
> its
> feature set and stability (foreign keys, etc), if the speed was good 
> that
> was a added bonus. I enjoy doing benchmarks from time to time
> (http://users.altec.org/~russ/benchmarks.html), if you really want to 
> know
> maybe I could help. Nothing against MySQL many people use it and it 
> works
> good for them. PostgreSQL has just really impressed me and has proven 
> to
> me to be really good and stable. Recently where I work we moved all our
> projects from Oracle to PostgreSQL, with the good documentation and
> community support that PostgreSQL offers I would say we have better
> performance and stability with PostgreSQL. Of course part of that 
> reason
> could be we didn't have a Oracle specialized DBA on staff.
>
> It's pretty tough to do benchmarks, as slight configurations in the
> database could make a large difference. I wouldn't be the best at
> optimizing MySQL so there would be a bias right there.

Very true.  And I'm not very good at optimizing either.. I'm a bit of 
an opportunist user in both cases, but have never done much to optimize 
either.

I'm more or less curious to see a few things... how anthill 0.3 
compares to 0.2 in terms of speed since I cleaned up some code and 
queries (ie. instead of doing SELECT * I'm just grabbing what I need), 
and also how mysql vs. postgresql compare (in terms of Anthill).

---
MandrakeSoft Security; http://www.mandrakesecure.net/
Online Security Resource Book; http://linsec.ca/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers