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
Slow performance when executing SQL scripts as non-SYSDBA user [CORE5966] #6220
Comments
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Modified by: @AlexPeshkoffreporter: Alexander Peshkov [ alexpeshkoff ] => Paul Reeves [ paul_reeves ] |
Commented by: @AlexPeshkoff Fixing this issue for FB4 should be done together with fixing security classes cache in order to make it support 'SQL SECURITY DEFINER' correctly, therefore I reassign it. |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] => Roman Simakov [ roman-simakov ] |
Modified by: @AlexPeshkoffFix Version: 3.0.5 [ 10885 ] |
Commented by: Ivan Pisarevsky (ivan_pisarevsky) Roman, I have test case for this bug (database+script). |
Commented by: Ivan Pisarevsky (ivan_pisarevsky) I have tested on build Firebird-3.0.5.33100 which included patch for this issue. |
Commented by: @romansimakov Fix in 3058fa4 All other tests were passed OK, including my tests for SQL SECURITY. Ivan, could you to test as well? This should be fixed in snapshot 4.0.0.1566 or higher. |
Commented by: @romansimakov Attached http://prep.sh is my script I used to test. The results are: real 0m37,112s real 0m47,582s NOW: real 0m37,139s real 0m37,043s |
Modified by: @romansimakovAttachment: http://prep.sh [ 13363 ] |
Commented by: Ivan Pisarevsky (ivan_pisarevsky) >Ivan, could you to test as well? This should be fixed in snapshot 4.0.0.1566 or higher. Two weeks later. |
Commented by: @dyemanov Any status update on this ticket? Ivan, did you have a chance to test the v4 snapshot? |
Commented by: Ivan Pisarevsky (ivan_pisarevsky) I'm so sorry... I didn't test v4. migration 2.5 to 3.0 in progress. only one server on 2.5 remained and then test v4. |
Can we close this issue? |
Suggest to close - no reply from author for a lo-o-o-ong time, and existing tests show that it's solved. |
Agreed |
…non-SYSDBA user (used for >2 years in IBP)
Submitted by: @reevespaul
Attachments:
prep.sh
Votes: 2
When a set of approxiamtely 30-50 SQL scripts containing updates of single records in various tables is executed as non-SYSDBA user granted rights to all required objects it takes 3-4 times more time compared with SYSDBA.
Commits: 2bf6198
The text was updated successfully, but these errors were encountered: