1. Chew LM
  2. Valentina Studio
  3. Tuesday, August 07 2018, 08:44 AM
  4.  Subscribe via email
Hi,

I tried to load the dump generated earlier with VStudio and it took a long time to complete.

It is because the dump generated by VStudio uses multiple INSERT to insert multiple data (i had 50K row to insert, this took a few minute).

Is it to provide an option to generate the dump with only a single Insert for these data?
Like how Adminer did it (Show below), this will speed up data insert significantly.

-- VStudio Dump data of "state_list" -------------------------------
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '1', 'JHR', 'Johor' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '2', 'KDH', 'Kedah' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '3', 'KTN', 'Kelantan' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '4', 'KUL', 'Wilayah Persekutuan Kuala Lumpur' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '5', 'LBN', 'Wilayah Persekutuan Labuan' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '6', 'MLK', 'Melaka' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '7', 'NSN', 'Negeri Sembilan' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '8', 'PHG', 'Pahang' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '9', 'PJY', 'Wilayah Persekutuan Putra Jaya' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '10', 'PLS', 'Perlis' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '11', 'PNG', 'Pulau Pinang' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '12', 'PRK', 'Perak' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '13', 'SBH', 'Sabah' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '14', 'SGR', 'Selangor' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '15', 'SRW', 'Sarawak' );
INSERT INTO `state_list`(`state_id`,`state_code`,`state_name`) VALUES ( '16', 'TRG', 'Terengganu' );


-- Adminer Dump data of "state_list" -------------------------------
INSERT INTO `state_list` (`state_id`, `state_code`, `state_name`) VALUES
(1, 'JHR', 'Johor'),
(2, 'KDH', 'Kedah'),
(3, 'KTN', 'Kelantan'),
(4, 'KUL', 'Wilayah Persekutuan Kuala Lumpur'),
(5, 'LBN', 'Wilayah Persekutuan Labuan'),
(6, 'MLK', 'Melaka'),
(7, 'NSN', 'Negeri Sembilan'),
(8, 'PHG', 'Pahang'),
(9, 'PJY', 'Wilayah Persekutuan Putra Jaya'),
(10, 'PLS', 'Perlis'),
(11, 'PNG', 'Pulau Pinang'),
(12, 'PRK', 'Perak'),
(13, 'SBH', 'Sabah'),
(14, 'SGR', 'Selangor'),
(15, 'SRW', 'Sarawak'),
(16, 'TRG', 'Terengganu');
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello, yes, there is such an option:
"Use separate INSERT command for each row"
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
This option is always enabled by default and it is necessary to uncheck it each time. We'll save it into user preferences.
The reason was that there may be too many rows for one insert.
Does Adminer put any number of rows into insert command or produces a few inserts, for example?
I think it can also be an option to split a large number of rows into a few inserts.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Chew LM Accepted Answer
Thanks, didn't noticed that was there.

Yes, Adminer does split the 50K row into multiple Inserts, it split into about 17K row per insert.

I agree that having an option to set the max limit of row that each insert can contain would be a useful feature to have.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
This option will be available in the next build.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Chew LM Accepted Answer
Awesome! thanks. :D
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.