-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/31/06 17:17, Tomi NA wrote: > 2006/10/31, Albe Laurenz <all@xxxxxxxxxxxxxxxxx>: [snip] > It's a good enough solution in most cases, but when the rowcount > starts to skyrocket, it simply doesn't seem to cut it (at least I > couldn't make it to). To load 1,5M rows (~230MB of INSERT statements), > I used gvim (wonderful tool!) to transform the INSERT statements into > a CSV file and then used an ETL (kettle - another wonderful tool) tool > to import the data into the database. > This could have probably been done much easier: I'd welcome a helpful > hint so as I know next time. :) Unix is chock full of streaming text manipulation tools. In this case, awk, Perl or Python would work well. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFFR+NKS9HxQb37XmcRAo3XAKDr2V7T//IjcRIKoHe6IH01eqrE9gCfe8CO g8eLsgHs7AtNJT6+F/2Byj4= =RT7u -----END PGP SIGNATURE-----
