On 05/10/2010 12:34 PM, Bill Arnold wrote: > 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 >
If I understand the article correctly, TPF was targeted for IBM's zSeries mainframes, which runs on IBM's OS only. That's likely where the 25,000 transaction per seconds originated. The new z/TPF will run on regular servers under Linux and other OS(s). For JOY! DB2 is better know as IBM's database, but having z/TPF come out as an open source product is great. Is it free? One advantages of running PostgreSQL is it's free. I remember downloading a 30 day test version of DB2 to RadHat Linux 4 or 5, so DB2 has been around on Linux for a long time, but you may have to pay big time, depending on use, if you opt for a license. I'm posting this email as I run out the door to take care of an errand. Be back soon. Regards, LelandJ > >> -----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/4be868ce.4010...@mail.smvfp.com ** 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.