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-issue-importer opened this issue May 16, 2017 · 10 comments
Closed

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

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented May 17, 2017

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 19, 2017

Commented by: @hvlad

Jiri,
do you confirm the fix ?

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 22, 2017

Commented by: @cincuranet

Yes. I do confirm it to be fixed.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 22, 2017

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 22, 2017

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 22, 2017

Commented by: @cincuranet

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 22, 2017

Commented by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 22, 2017

Commented by: @cincuranet

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 25, 2017

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 25, 2017

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