[firebird-support] How do you name your foreign key column?

2014-12-18 Thread brucedickin...@wp.pl [firebird-support]
Hi guys, in our database I see two naming conventions for foreign key columns: 1. SOMETHING_ID 2. ID_SOMETHING which one do you use and why? I see that in system tables the first convention is used (f.e. MON$TRANSACTION_ID, MON$ATTACHMENT_ID) Thanks for your opinion.

Re: [firebird-support] Re: performance of subselect with group by

2014-12-18 Thread Björn Reimer bjoern.rei...@fau.de [firebird-support]
Hello, thanks Set, makes my test unnecessary! But I'm thinking a little bit about my original problem. Would it make sense to add a tracker entry for optimization of subselects without reference to outer query? I think that they should get evaluated and transformed to something

Re: [firebird-support] How do you name your foreign key column?

2014-12-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-12-2014 15:59, brucedickin...@wp.pl [firebird-support] wrote: Hi guys, in our database I see two naming conventions for foreign key columns: 1. SOMETHING_ID 2. ID_SOMETHING which one do you use and why? I see that in system tables the first convention is used (f.e.

[firebird-support] Re: performance of subselect with group by

2014-12-18 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Hello, thanks Set, makes my test unnecessary! But I'm thinking a little bit about my original problem. Would it make sense to add a tracker entry for optimization of subselects without reference to outer query? I think that they should get evaluated and transformed to something

RE: [firebird-support] Re: In Firebird can you tell when a Stored procedure has been compiled

2014-12-18 Thread 'Edward Mendez' emendez...@nc.rr.com [firebird-support]
Hi All, Can you tell in Firebird 2.1.x or 2.5.x when a stored procedure has been compiled? Thank you, Edward Mendez

Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server

2014-12-18 Thread af_12...@yahoo.com [firebird-support]
Hi Louis yes true, with fiew connections i do not risk big troubles about it , but as for now , i am just making some smal test writing blob fields on an empy db and on a w2008 active directory server and i get 10x times operation slower then my client i know i need a support designing the

[firebird-support] Unrelated Sites Using Firebird 2.1.3 on Server 2008 R2 - FB Service Stopping Several Times in the Past Week

2014-12-18 Thread rogu...@yahoo.com [firebird-support]
Hey all. I work with a software development company that uses Firebird for our database engine. We have several clients that have complained of losing connectiong to their database in the past week (since about last Thursday. Upon investigation - the Firebird service was somehow stopped

[firebird-support] Re: How do you name your foreign key column?

2014-12-18 Thread brucedickin...@wp.pl [firebird-support]
Thanks, had no idea about USING clause :)

RE: [firebird-support] Re: In Firebird can you tell when a Stored procedure has been compiled

2014-12-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Thu, 18 Dec 2014 18:28:56 -0500, 'Edward Mendez' emendez...@nc.rr.com [firebird-support] firebird-support@yahoogroups.com wrote: Can you tell in Firebird 2.1.x or 2.5.x when a stored procedure has been compiled? It is compiled (to BLR) at the moment you execute the CREATE, ALTER, CREATE OR

Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server

2014-12-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18 Dec 2014 17:32:40 -0800, af_12...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: Hi Louis yes true, with fiew connections i do not risk big troubles about it , but as for now , i am just making some smal test writing blob fields on an empy db and on a w2008