Skip to content

making everything less chatty #525

Open
@Spirch

Description

for every table there is seven EF queries sent, in a case of SetOutputIdentity = true which include IncludeGraph = true

  1. create table
  2. create output table
  3. alter columns
  4. merge to destination table
  5. select to retrieve the identity
  6. delete table
  7. delete output table

for a single table, this could be reduced, looking at the adapter code, it might be a matter of collecting the sql query and concatenating them together in a way that make sense to execute in batch

next issue about this is if there is a lot of tables, that series of query will be execute for each table, so if there is 100 tables, there will be 700 execute queries, if all the queries can be done in batch / grouped together it would reduce the chattyness of the bulk process

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions