0002378: [tMysqlOutput] use MySQL specific extended insert

Viewing Issue Advanced Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0002378

[Talend Open Studio] Perl components

feature

always

2007-10-30 12:00

2008-01-15 16:57

Reporter

plegall

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

2.3.0M2

Product Version

Target Version

Product Build

Summary

0002378: [tMysqlOutput] use MySQL specific extended insert

Description

With MySQL, there is a specific "extended" mode for inserts. Instead of inserting lines one by one, a single insert query can insert several rows :

insert into users
  (name, age)
  values
  ('plegall', 26),
  ('smallet', 32),
  ('mhelleboid', 29)
;

This MySQL specific method is much faster than doing N queries.

Steps To Reproduce

Additional Information

Tags

No tags attached.

generated language

workload (in half days)

Attached Files

Relationships

related to

0002503

closed

mhirt

[tMysqlOutput] use MySQL specific extended insert

Notes
(0005350) plegall (reporter) 2007-11-21 13:58	Feature added on trunk in [Subversion, tos] r7142. Performance improvement is around 4 to 5 times faster :-)

Issue History
Date Modified	Username	Field	Change
2007-10-30 12:00	plegall	New Issue
2007-10-30 12:00	plegall	Status	new => feedback from Talend
2007-10-30 12:00	plegall	Assigned To	=> plegall
2007-11-20 09:04	plegall	Status	feedback from Talend => assigned
2007-11-21 13:58	plegall	Note Added: 0005350
2007-11-21 13:58	plegall	Status	assigned => resolved/needs doc
2007-11-21 13:58	plegall	Resolution	open => fixed
2007-11-21 13:58	plegall	Fixed in Version	=> 2.3.0M2
2007-11-21 13:58	plegall	Note Added: 0005351
2007-11-21 14:02	plegall	Note Deleted: 0005351
2007-11-21 14:04	mhirt	Issue cloned	0002503
2007-11-21 14:04	mhirt	Relationship added	related to 0002503
2008-01-15 16:57	plegall	Status	resolved/needs doc => closed

Mantis 1.1.6[^]