Update vs Insert in SQL
May 10th, 2008 by sherlock Hit :: 542
PostgreSQL 7.03
| Normal | autocommit on | fsync off |
| insert update | insert update | insert update |
| 5:16 6:46 | n/a n/a | 0:10 0:18 |
I thing that insert is faster than the update statement, so if u have to choice that statement, u better choice an insert.