pricesnake
New Member
I've got a 2Gb XML file that I want to load into a single table in MySQL.The number of records/rows is ~140,000, but the default behavior of the LOAD XML function in MYSQL seems to depart from linear time.Cutting the data into smaller pieces, I get the following performance (dropped table between each LOAD)all were: Deleted: 0 Skipped: 0 Warnings: 0 5000 row(s) affected Records: 5000 4.852 sec10000 row(s) affected Records: 10000 20.670 sec15000 row(s) affected Records: 15000 80.294 sec20000 row(s) affected Records: 20000 202.474 secThe XML is well formed. I've tried:SET FOREIGN_KEY_CHECKS=0;SET UNIQUE_CHECKS=0;What can I do to load it in a reasonable time that doesn't involve cutting it into a dozen pieces?