On Wed, 8 Mar 2006, Jacek Becla wrote: > The fastest way to do bulk ingest in MySQL is through ascii file > (20x faster than any other method).
This concurs with our database benchmarking we did with MySQL and PostgreSQL for the CARMA telescope. In both cases, ascii file bulk ingest was the faster than other methods, MySQL was the clear winner between the two. For the arguments regarding conversions to internal formats that Jacek related, I suspect that this fact is applicable to most databases. cheers, Ray _______________________________________________ LSST-data mailing list [email protected] http://www.lsstmail.org/mailman/listinfo/lsst-data
