0000509: new component tMysqlUpdateBulkExec

Viewing Issue Advanced Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0000509

[Talend Open Studio] Perl components

feature

N/A

2007-01-22 06:45

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

0000509: new component tMysqlUpdateBulkExec

Description

Instead of updating line by line with a tDBOutput, loading data in a temporary file and then updating the main table with a join update... would be much more efficient.

Steps To Reproduce

Additional Information

Tags

No tags attached.

generated language

workload (in half days)

Attached Files

Relationships

Notes
(0005473) plegall (reporter) 2007-11-29 14:27	Added on trunk in [Subversion, tos] r7291 tMysqlUpdateBulkExec takes a file as parameter tMysqlOutputUpdateBulkExec takes a flow as input On a 1M lines table with fields {id, firstname, lastname, age, weight}, I've performed an update of 100K ids. 13.0 seconds for tMysqlOutput, 2.2 seconds for tMysqlOutputUpdateBulkExec.

Issue History
Date Modified	Username	Field	Change
2007-01-22 06:45	plegall	New Issue
2007-01-22 16:44	ccarbone	Assigned To	=> plegall
2007-01-22 16:44	ccarbone	Status	new => feedback from Talend
2007-11-29 12:08	plegall	Status	feedback from Talend => assigned
2007-11-29 14:27	plegall	Note Added: 0005473
2007-11-29 14:27	plegall	Summary	new component tMysqlUpdateBulk => new component tMysqlUpdateBulkExec
2007-11-29 14:27	plegall	Status	assigned => resolved/needs doc
2007-11-29 14:27	plegall	Resolution	open => fixed
2007-11-29 14:27	plegall	Fixed in Version	=> 2.3.0M2
2008-01-15 16:57	plegall	Status	resolved/needs doc => closed

Mantis 1.1.6[^]