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');