Project

General

Profile

Actions

Performance » History » Revision 2

« Previous | Revision 2/5 (diff) | Next »
bford -, 09/28/2006 01:54 PM


The follow are the results of some basic tests run on 09/28/06:

{{{

==========================================================
DBD::Pg
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:43:05 PM
Selecting 1000000 rowsEnd: 01:43:08 PM

Start: 01:43:08 PM
Insert 1000000 rows 1000 at a time End: 01:43:18 PM

Start: 01:43:18 PM
Insert 1000000 rows one at a time End: 01:45:16 PM

Start: 01:45:16 PM
Insert 1000000 prepared rows 1000 at a time End: 01:45:23 PM

==========================================================
DBD::nodbcng_nobuffer
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:45:53 PM
Selecting 1000000 rowsEnd: 01:45:56 PM

Start: 01:45:56 PM
Insert 1000000 rows 1000 at a time End: 01:46:05 PM

Start: 01:46:05 PM
Insert 1000000 rows one at a time End: 01:48:07 PM

Start: 01:48:07 PM
Insert 1000000 prepared rows 1000 at a time End: 01:48:14 PM

==========================================================
DBD::odbcng_buffer
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:48:44 PM
Selecting 1000000 rowsEnd: 01:48:48 PM

Start: 01:48:48 PM
Insert 1000000 rows 1000 at a time End: 01:48:57 PM

Start: 01:48:57 PM
Insert 1000000 rows one at a time End: 01:51:00 PM

Start: 01:51:00 PM
Insert 1000000 prepared rows 1000 at a time End: 01:51:08 PM

==========================================================
DBD::PGDG.ODBC
Cleaning up before test, Truncating insert_test, Analyzing test
Start: 01:51:38 PM
Selecting 1000000 rowsEnd: 01:51:42 PM

Start: 01:51:42 PM
Insert 1000000 rows 1000 at a time End: 01:51:52 PM

Start: 01:51:52 PM
Insert 1000000 rows one at a time End: 01:53:46 PM

Start: 01:53:46 PM
Insert 1000000 prepared rows 1000 at a time End: 01:53:54 PM

}}}

Updated by bford - over 17 years ago · 2 revisions