From: Mark Radulovich <radulovich@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: ODBC Benchmark
Date: Tue, 1 Aug 2000 13:16:29 -0700 (PDT)
Message-ID: <20000801201629.18829.qmail@web108.yahoomail.com> (raw)
Just in case anyone is interested, I benchmarked PG 7 and NT/IIS yesterday. I
ran an .ASP script that inserted 2000 rows using ODBC(one numeric column, one
varchar(50)) into a PG 7.0.2 database running on a Redhat Linux 6.2 computer.
I ran into a few small problems, but they mostly had to do with the script
reloading before finishing. I got roungly 600,000 inserts in a 21 hour period -
that works out to 7.9 inserts per second!! Hardware is as follows:
Machine 1: Machine 2:
========== ==========
P400 P400
128 MB RAM 128 MB RAM
NT 4 RH Linux 6.2
IIS 4 PostgreSQL 7.02
IE 5
Note that although this test is not entirely scientific, it does show what PG7
is capable of.
Enjoy,
Mark
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: radulovich@yahoo.com
Subject: Re: ODBC Benchmark
In-Reply-To: <20000801201629.18829.qmail@web108.yahoomail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox