Performance » History » Revision 2
Revision 1 (bford -, 09/28/2006 12:52 PM) → Revision 2/5 (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, test
Truncating insert_test, insert_test
Analyzing test
Start: 01:43:05 12:26:41 PM
Selecting 1000000 rowsEnd: 01:43:08
SELECT * FROM accounts
End: 12:26:44 PM
Start: 01:43:08 12:26:44 PM
Insert 1000000 rows 1000 at a time
End: 01:43:18 12:26:53 PM
Start: 01:43:18 12:26:53 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 12:28:51 PM
==========================================================
DBD::nodbcng_nobuffer
Cleaning up before test, test
Truncating insert_test, insert_test
Analyzing test
Start: 01:45:53 12:29:21 PM
Selecting 1000000 rowsEnd: 01:45:56
SELECT * FROM accounts
End: 12:29:25 PM
Start: 01:45:56 12:29:25 PM
Insert 1000000 rows 1000 at a time
End: 01:46:05 12:29:35 PM
Start: 01:46:05 12:29:35 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 12:31:37 PM
==========================================================
DBD::odbcng_buffer
Cleaning up before test, test
Truncating insert_test, insert_test
Analyzing test
Start: 01:48:44 12:32:07 PM
Selecting 1000000 rowsEnd: 01:48:48
SELECT * FROM accounts
End: 12:32:10 PM
Start: 01:48:48 12:32:10 PM
Insert 1000000 rows 1000 at a time
End: 01:48:57 12:32:20 PM
Start: 01:48:57 12:32:20 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 12:34:17 PM
==========================================================
DBD::PGDG.ODBC
Cleaning up before test, test
Truncating insert_test, insert_test
Analyzing test
Start: 01:51:38 12:34:47 PM
Selecting 1000000 rowsEnd: 01:51:42
SELECT * FROM accounts
End: 12:34:50 PM
Start: 01:51:42 12:34:50 PM
Insert 1000000 rows 1000 at a time
End: 01:51:52 12:35:00 PM
Start: 01:51:52 12:35:00 PM
Insert 1000000 rows one at a time
End: 01:53:46 12:37:00 PM
Start: 01:53:46 PM
Insert 1000000 prepared rows 1000 at a time End: 01:53:54 PM
}}}