1. Chew LM
  2. Valentina Studio
  3. Dienstag, August 07 2018, 08:44 AM
  4.  Abonnieren via E-Mail
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');
Kommentar
There are no comments made yet.
Chew LM Akzeptierte Antwort
Awesome! thanks. :D
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
This option will be available in the next build.
Anhänge
Kommentar
There are no comments made yet.
Chew LM Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello, yes, there is such an option:
"Use separate INSERT command for each row"
Anhänge
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories