In your flow, what does the data look like? Are you splitting it into individual records, then converting to SQL (probably via JSON) and calling PutSQL? If so, that's not going to be very performant; the PutDatabaseRecord processor combines all that together so you can leave your data in its original state (i.e. many records in one flow file). For benchmarking PutDatabaseRecord (PDR), you could provide sample data via GenerateFlowFile, run a few through PDR, and check the provenance events for fields such as durationMillis or calculations like (timestampMills - lineageStart).
Regards, Matt On Wed, Feb 6, 2019 at 2:07 PM l vic <[email protected]> wrote: > > I have performance issues with PutSQL i my flow... Is there some way to > benchmark time required to write certain number of records to table from > GenerateFlowFile? > Thank you,
