Issue Details (XML | Word | Printable)

Key: CORE-5966
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Roman Simakov
Reporter: Paul Reeves
Votes: 2
Watchers: 9
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Slow performance when executing SQL scripts as non-SYSDBA user

Created: 18/Nov/18 07:03 PM   Updated: 14/Dec/19 10:48 AM
Component/s: Engine
Affects Version/s: 4.0 Alpha 1, 3.0.3, 3.0.4
Fix Version/s: 3.0.5

File Attachments: 1. File prep.sh (0.5 kB)

Environment: Database should be located on RAM filesystem in order to easier reproduce an issue.

QA Status: No test


 Description  « Hide
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.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov made changes - 18/Nov/18 07:04 PM
Field Original Value New Value
Assignee Alexander Peshkov [ alexpeshkoff ]
Alexander Peshkov made changes - 18/Nov/18 07:04 PM
Reporter Alexander Peshkov [ alexpeshkoff ] Paul Reeves [ paul_reeves ]
Alexander Peshkov made changes - 18/Nov/18 07:08 PM
Assignee Alexander Peshkov [ alexpeshkoff ] Roman Simakov [ roman-simakov ]
Alexander Peshkov made changes - 18/Nov/18 07:08 PM
Fix Version/s 3.0.5 [ 10885 ]
Dmitry Yemanov made changes - 24/Jul/19 07:08 AM
Comment [ test ]
Roman Simakov made changes - 24/Jul/19 07:11 AM
Attachment prep.sh [ 13363 ]