Romcenter

INSERT INTO `table1` VALUES
(a, b, c, d),
(e, f, g, h),
(w, x, y, z);

INSERT INTO `table1` VALUES (a, b, c, d);
INSERT INTO `table1` VALUES (e, f, g, h);
INSERT INTO `table1` VALUES (w, x, y, z);

[quote="RomCenter"]And how do you insert a 'huge amount of roms at once' ?
There is no sql command to batch import.

I already do an uncommited load to speed up things.[/quote]

well, here is an example for MySQL...

[u][b]fast insert[/b][/u]
[code]INSERT INTO `table1` VALUES
(a, b, c, d),
(e, f, g, h),
(w, x, y, z);[/code]

[u][b]slow insert[/b][/u]
[code]INSERT INTO `table1` VALUES (a, b, c, d);
INSERT INTO `table1` VALUES (e, f, g, h);
INSERT INTO `table1` VALUES (w, x, y, z);[/code]

And how do you insert a 'huge amount of roms at once' ?
There is no sql command to batch import.

I already do an uncommited load to speed up things.

wouldn't when adding rom files, especially when you add your rom directory for the first time, to precache several roms in an array and then insert an huge amount of roms at once, instead to do one sql insert per game?

Melerix, look up the term Daltonism. Not sure though if Bzalel is trolling or serious.

reasons ?

Sorry for my English. Automatic translate by google.

Please change the color of the icons of the roms
combination to avoid: red / green
Thank you.