Re: INSERT extremely slow with large data sets

On Fri, Nov 14, 2003 at 06:36:41PM +1100, Slavisa Garic wrote:

> Rows Present        Start Time        Finish Time
> ------------------------------------------------------------
> 100            1068790804.12           1068790804.12
> 1000            1068790807.87          1068790807.87
> 5000            1068790839.26        1068790839.27
> 10000            1068790909.24          1068790909.26
> 20000            1068791172.82        1068791172.85
> 30000            1068791664.06        1068791664.09 
> 40000            1068792369.94        1068792370.0
> 50000            1068793317.53        1068793317.6
> 60000            1068794369.38        1068794369.47

> [too slow]

Ok, so inserting 60000 rows seems to take 0.09 seconds, and inserting
5000 takes only 0.01.  And your problem is exactly what?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Coge la flor que hoy nace alegre, ufana. ¿Quién sabe si nacera otra mañana?"