RE: [firebird-support] Understanding query performance changes

Hi, In upgrading from Firebird 2.0 to Firebird 2.5, I have a query that has dramatically changed performance. It would be great if I could understand the performance information given in FlameRobin, and how this can be used to return the query to its former performance. The query run is the

Re: [firebird-support] Why a database grows after a cycle backup/restore?

The source database has 3.1 Gb but after the backup/restore have 4.2 Gb Did you specify a larger page size for the restore? Regards Stefan

[firebird-support] guest user

Hello, sorry if this is a silly question, but I'm googling it and can't find the answer... I need to create test user which is not allowed to drop or alter anything of the database metadata. Just read or write records from some tables... I'm using FB 2.5 Thanks!

Re: [firebird-support] guest user

hej, - create custom user - grant needed rights for user on table hth, marcus Sergio wrote: Hello, sorry if this is a silly question, but I'm googling it and can't find the answer... I need to create test user which is not allowed to drop or alter anything of the database metadata. Just

Re: [firebird-support] Re: Does Firebird have a way to reference similar named fields? (Like MONTH_1 thru MONTH_120)

Thanks for your reply. MONTH_* are not fields in a table, they are output parameters of my stored procedure. Mike - Original Message - From: thp_pkmi To: firebird-support@yahoogroups.com Sent: Tuesday, June 18, 2013 10:52 PM Subject: [firebird-support] Re: Does Firebird

Re: [firebird-support] Re: Does Firebird have a way to reference similar named fields? (Like MONTH_1 thru MONTH_120)

Maybe a delimitated output string can help ... (something like value1:10|value2:20|value3:40| ... valueN:X) El 19/06/2013 10:37 a.m., Softtech Support escribió: Thanks for your reply. MONTH_* are not fields in a table, they are output parameters of my stored procedure. Mike -

[firebird-support] Firebird db statistics and performance

Hi - can anyone comment on these db stats - I guess the transaction id's are not good with such a difference. The db is being abused somewhat with users not logging out at night hence the sweep we run (I assume) is having little effect. The consequence of all this is deteriorating perfomance

RE: [firebird-support] Firebird db statistics and performance

Hi - can anyone comment on these db stats - I guess the transaction id's are not good with such a difference. The db is being abused somewhat with users not logging out at night hence the sweep we run (I assume) is having little effect. The fact that users are not logging out, is not the

[firebird-support] Duplicate values in system index

gbak:restoring privilege for user SYSDBA gbak:restoring SQL role: RDB$ADMIN gbak: ERROR: attempt to store duplicate value (visible to active transactions) in unique index RDB$INDEX_39 RDB$INDEX_39 relation name is RDB$ROLES. RDB$ROLES has one row, RDB$ADMIN. Where do I go from here?

[firebird-support] RE: Duplicate values in system index

Rick, gbak:restoring privilege for user SYSDBA gbak:restoring SQL role: RDB$ADMIN gbak: ERROR: attempt to store duplicate value (visible to active transactions) in unique index RDB$INDEX_39 RDB$INDEX_39 relation name is RDB$ROLES. RDB$ROLES has one row, RDB$ADMIN. Are you trying

[firebird-support] Re: Understanding query performance changes

Hi Set, Thank you very much for your help! Your query runs much faster than even the original query did, and is easier to understand. Regards, Gareth --- In firebird-support@yahoogroups.com, Svein Erling Tysvær svein.erling.tysvaer@... wrote: Hi, In upgrading from Firebird 2.0 to

[firebird-support] Re: SQLState=HY000; unsuported on-disk structure for file D:\HIS\Database\HIS_sample

i just installed interbase v 7.5 but still cant access the database?

Odp: [firebird-support] Re: SQLState=HY000; unsuported on-disk structure for file D:\HIS\Database\HIS_sample

Hi, 7.5 is not the latest version of interbase And remember this is Firebird not IB group Regards, Karol Bieniaszewski - Reply message - Od: Eliezer clea_l...@rocketmail.com Do: firebird-support@yahoogroups.com Temat: [firebird-support] Re: SQLState=HY000; unsuported on-disk structure