Hi Leland, For perspective on high end database performance, compare both to TPF (25,000 transactions per second) http://www.linuxinsider.com/story/37518.html?wlc=1273511918
" ... but what is most significant is the system's compatibility with Linux. This feature opens the door for many more programmers and administrators who may want to work with it." I've written applications for TPF (Avis rent-a-car) years ago. Kinda/sorta like VFP, it reads records into "work areas" (levels). Records are chained (linked) to enable reading back and forth through sets. At the time it was assembler only, but that may have changed with z/TPF. Bill > -----Original Message----- > From: profoxtech-boun...@leafe.com > [mailto:profoxtech-boun...@leafe.com] On Behalf Of Leland Jackson > Sent: Monday, May 10, 2010 12:31 PM > To: profoxt...@leafe.com > Subject: [NF] Postgres vs. SQL Server > > > Results of test performed between MSSQL and PostgreSQL: > > #------------------------------- > Excerpt: > > 5 Conclusions > This paper compares the performance and scaling of the BenchmarkSQL > workload running > on Red Hat Enterprise Linux 5.4 with that of the same workload on > Windows Server 2008 R2 > Enterprise. The database servers used were HP ProLiant DL370 > G6 servers > equipped with > 48 GB of RAM and comprised of dual sockets, each with a 3.2 GHz Intel > Xeon W5580 > Nehalem processor (totaling 8 cores). > The data presented in this paper establishes that a common > OLTP workload > on PostgreSQL > can contend with SQL Server and with minimal tuning, is capable of > outperforming SQL > Server using the same load in an enterprise environment. > The number of actual users and throughput supported in any specific > customer situation > would naturally depend on the specifics of the application > used and the > degree of user > activity. > > http://pgsnake.blogspot.com/2010/05/postgres-vs-sql-server.html > > #---------------------------------- > > Regards, > > LelandJ > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1156e0d39fa1488a8a6ee06fccaaa...@bills ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
