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

Every other execution of embedded isql slow [CORE5540] #5808

Closed
firebird-automations opened this issue May 16, 2017 · 10 comments
Closed

Every other execution of embedded isql slow [CORE5540] #5808

firebird-automations opened this issue May 16, 2017 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @cincuranet

I have a weird behavior on FB 3.0.2 32b, confirmed on 3 machines
(Win2012 R2, Win 10 CU, Win 10 AU). When I execute `isql -x
database.fdb` the first run is fast. When I execute it then again the
run is slow, like 5-10x slower. Then again fast and slow, fast, slow,
fast, slow etc.

The whole repro is here
http://www.uschovna.cz/zasilka/MAMF5RKT9XYHSAL7-GDI/ . Just run test.bat
from cmd two times.

Commits: cc102b7 8474689

====== Test Details ======

Can not use embedded within fbtest framework (at least nowadays).
Could not reproduce on XNET: every run of 'isql -x' was completed quickly for DB with 300+ tables.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Jiri,
do you confirm the fix ?

@firebird-automations
Copy link
Collaborator Author

Commented by: @cincuranet

Yes. I do confirm it to be fixed.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 3.0.3 [ 10810 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Not enough information

Test Details: File http://www.uschovna.cz/zasilka/MAMF5RKT9XYHSAL7-GDI/ -- no more avaliable.
Jiri, can you plese upload it again in some place or send to p519446 at http://yandex.ru.

@firebird-automations
Copy link
Collaborator Author

Commented by: @cincuranet

I no longer have the app. But it was really just running `isql -x database.fdb` and nothing else.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Was this database empty or did contain some / lot of objects ?

@firebird-automations
Copy link
Collaborator Author

Commented by: @cincuranet

It did contain some objects. The number doesn't really matter, because the problem happens at authentication level.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Not enough information => Cannot be tested

Test Details: File http://www.uschovna.cz/zasilka/MAMF5RKT9XYHSAL7-GDI/ -- no more avaliable.
Jiri, can you plese upload it again in some place or send to p519446 at http://yandex.ru.

=>

Can not use embedded within fbtest framework (at least nowadays).
Could not reproduce on XNET: every run of 'isql -x' was completed quickly for DB with 300+ tables.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants