On 7/13/06, Christian Rengstl <[EMAIL PROTECTED]> wrote:
Good morning list,the following query takes about 15 to 20 minutes for around 2 million lines in the file myfile.txt, but with 8 million lines it takes around 5 hours and i just don't understand why there is such a huge discrepancy in performance.
on the surface it doesn't make sense, can you post an explain analyze? merlin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
