Odbcng

Performance » History » Revision 3

Revision 2 (bford -, 09/28/2006 01:54 PM) → Revision 3/5 (bford -, 09/28/2006 01:58 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 rows End: 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 rows End: 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 rows End: 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 rows End: 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 


 }}}