[firebird-support] no permission for INSERT access to TABLE PLG$SRP_VIEW
Having Issues with 'create user' with Firebird 3.0 It works fine on one computer where we are testing but not the other. We think we did the same thing on both computers. Installed Firebird Created SYSDBA Account Created PRIVATEADMIN Account Granted Role RDB$ADMIN to PRIVATEADMIN (in security3.fdb) Log into our database as PRIVATEADMIN with ROLE RDB$ADMIN. Where committing the Create User command, I get the error in the subject line no permission for INSERT access to TABLE PLG$SRP_VIEW The other computer adds the user without a problem. What am I doing wrong? Thanks Todd
RE: [firebird-support] Left outer join with stored procedure
You need to make sure your stored procedure returns the variable that you are going to join with. Here is an example: SELECT a.propid, b.EconomicZone_Code, a.MTQUST_Combo, a.Model_Code, a.Quality_Code, a.Structure_Code FROM Table1 a LEFT OUTER JOIN Procedure1(a.propid) b on b.propid = a.propid
[firebird-support] Backup/Restore Required ???
Wondering if a Backup/Restore is requird for moving from 2.5.2 to 2.5.3? I have done it here without any issues so far, but thought I better ask the question. Todd Brasseur Compass Municipal Services Inc.
[firebird-support] Re: Backup/Restore Required ???
Thanks a bunch. Todd
[firebird-support] Re: How to rebuild all stored procedures / triggers
I use IB Expert. It will build a script that alters all your stored procedures to empty. Just the input and output parameters are in place. Then it alters them again populated. This means you don't need to be concerned in what order you create them. It also will build a script that will alter all your triggers. We do this periodically in our clients installations because we want all of them to have the exact same metadata.
[firebird-support] Re: Performance of Firebird (Superserver vs Superclassic, etc.)
Thanks
[firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)
Thought I would share some experience we have gained recently. We have an application consisting of a C++ Builder front end and Firebird 2.5 as the backend. Running on Windows. The database includes a ton of stored procedures with some fairly intricate calculations. A typical installation might have 45,000 records in the main table, with another 180 tables that can have a few records to a couple of hundred thousand of records in each of them. We had one main calculation routine that goes through the 45,000 records (one by one) and runs a bunch of stored procedures that populate once particular table in the database. This process was taking approx. 30 minutes for one client. We had an idea to change the calculation to divide the 45,000 records into smaller chunks and processing them at the same time in different threads. We are using 10 threads for this operation. This cut the processing time in half from 30 minutes to 15 minutes. Also, we had always run Firebird as Superserver. We decide to install Firebird as Superclassic in order to take advantage of the multiple processors that most of our clients have on their servers. The particular client above has 4 processors on his server. After changing the Firebird installation to Superclassic, the processing time went down to approx. 5 minutes. Needless to say, we are very happy with the results of this. Still doing some testing before getting this out to our client base. Todd Brasseur, A.M.A.A. Compass Municipal Services Inc. http://www.camalot.ca