Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

need to add a special option when declaring an external table, so that each insert ends with a flush file [CORE5688] #5954

Open
firebird-automations opened this issue Dec 28, 2017 · 2 comments
Open

need to add a special option when declaring an external table, so that each insert ends with a flush file [CORE5688] #5954

firebird-automations opened this issue Dec 28, 2017 · 2 comments
Labels
component: engine priority: major type: new feature

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: otinov (otinov)

need to add a special option when declaring an external table, so that each insert ends with a flush file
because after inserting the data you have to execute the query of the form "select max(id) from <external table>"
so that another transaction can see them
@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Such option will make every INSERT terrible slow, i don't think you really need it.

Another transaction of the same attachment could see inserted data, i believe.
I.e. you speak about different attachments, correct ?
Must add that EXTERNAL TABLE's is not good choice to work in concurrent environment.

As workaround i could recommend to run SELECT FIRST 1 * FROM EXT_TABLE when
INSERT's are done, it should flush internal buffer (if external file is larger than buffer size).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component: engine priority: major type: new feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations