On 2011/10/21 10:26 AM, Johan De Meersman wrote:
----- Original Message -----
From: "Alex Schaft"<al...@quicksoftware.co.za>
Got my app reading in a dump created with extended-inserts off, and
lumping all of the insert statements together. Works like a charm
Just for laughs, would you mind posting the on-disk size of your database, and
the restore time with both extended and single inserts?
ibdata1 currently sitting at 6 gigs. Without ext inserts about a minute
and a half and with a couple of seconds. I'm well aware of the speed
differences. That's why I'm now reading in the non extended and joining
the values together into big sql statements. This now takes about 10
seconds, but I'm still optimizing that.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
