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

Speed up meta-data updates for dropping external files [CORE823] #1209

Open
firebird-automations opened this issue Sep 1, 2004 · 5 comments
Open

Speed up meta-data updates for dropping external files [CORE823] #1209

firebird-automations opened this issue Sep 1, 2004 · 5 comments
Assignees
@hvlad
Labels
component: engine priority: major type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: mericksen (mericksen)

SFID: 1020512#⁠
Submitted By: mericksen

In our system, external tables are used as a means of
moving subsets of data from the server to remote
clients. The external table is accessed on the client
side and merged into their full set of data.

Currently, I can't zip up the created external
tables/files until the external tables are dropped. The
drop process (for all tables) takes a finite set of
time around 1 minute. It would be very helpful if the
drop process was optimized or the file locks could be
avoided so I could zip the file and do the cleanup after.

-Mark E.
@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2006-03-06 20:30
Sender: nuclearspike
Logged In: YES
user_id=864723

It may have to do with some of the tables being
exceptionally wide. One of the tables has 296 fields.
Vlad, I will send a table definition to your email.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2006-03-06 16:34
Sender: hvlad
Logged In: YES
user_id=879552

I'm unable to reproduce significant delays when dropping 100
external tables. My times is near 1.3 sec on execute 100
DROP TABLE statements (non autocommit) and near 0.5
sec for COMMIT after it.

Please provide reproducible test case

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-07-24 18:00
Sender: dimitr
Logged In: YES
user_id=61270

Vlad, could you please investigate the issue when time permits?

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

issuetype: New Feature [ 2 ] => Improvement [ 4 ]

SF_ID: 1020512 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10847 ] => Firebird [ 15288 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hvlad hvlad

Labels
component: engine priority: major type: improvement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@hvlad @firebird-automations