[BulkInsert] Order of records while using Bulk insert forge component

Back to Forums

Pranav Pandey

[BulkInsert] Order of records while using Bulk insert forge component

Question

Forge

Traditional Web

Application Type

Traditional Web

I have a question regarding the Bulk insert forge component. Is the order of record maintained while inserting the data in the database?

17 Jan

Daniel Kuhlmann

MVP

Hi Pranav,

To what order are you referring too?

Database records are not stored in a particular order, and the primary key is a technical key without any specific meaning. Performant sorting order should be implemented by index definitions on your entity.

Regards,

Daniel

17 Jan

1 reply

17 Jan

Show thread

Hide thread

Pranav Pandey

By order, I meant the order of the list that is passed to the bulk insert function

For example: is the record inserted in the same order (same sequence ) as shown below

	Col1	Col2	Col2
Row1	A	A	A
Row2	B	B	B
Row3	C	C	C
Row4	A	A	A
Row5	B	B	B
Row6	C	C	C
Row7	A	A	A
Row8	B	B	B
Row9	C	C	C

17 Jan

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines