Re: [firebird-support] Re: Need Speed Optimization for SQL

@Rob: Ya, this field is already a primary key in the same table and there a separate index created on this single column. On Thursday, 16 April 2015 9:58 AM, "Virgo Pärna virgo.pa...@mail.ee [firebird-support]" wrote:   On Wed, 15 Apr 2015 21:54:32 + (UTC), Vishal Tiwari vi

[firebird-support] Re: Need Speed Optimization for SQL

On Wed, 15 Apr 2015 21:54:32 + (UTC), Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > > > SELECT >   Sum(CRM_DOCUMENT_ITEMS.QUANTITY) AS Delivered, >   CRM_DOCUMENT_ITEMS.FK_JOB_ITEM > FROM >   CRM_DOCUMENT_ITEMS >   INNER JOIN CRM_DOCUMENT_HEADER ON CRM_DOCUMENT_ITEMS.FK_DO

Re: [firebird-support] Need Speed Optimization for SQL

Wow ! Do you have an index on CRM_JOB_ITEMS.PK_JOB_ITEMS ? On 16/04/2015 10:29 a.m., Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > @Rob: Your SQL is taking 28 seconds... > > > > On Thursday, 16 April 2015 3:56 AM, "Robert martin r...@chreos.com > [firebird-support]" wrote:

Re: [firebird-support] Need Speed Optimization for SQL

@Rob: Your SQL is taking 28 seconds... On Thursday, 16 April 2015 3:56 AM, "Robert martin r...@chreos.com [firebird-support]" wrote:   Hi Try replacing your IN statement with an EXISTS clause. Something like CRM_DOCUMENT_HEADER.DOCUMENT_TYPE = 1 AND EXISTS(select PK_JOB_ITEMS

Re: [firebird-support] Need Speed Optimization for SQL

Hi Try replacing your IN statement with an EXISTS clause. Something like CRM_DOCUMENT_HEADER.DOCUMENT_TYPE = 1 AND EXISTS(select PK_JOB_ITEMS from CRM_JOB_ITEMS where PK_JOB_ITEMS = CRM_DOCUMENT_ITEMS.FK_JOB_ITEM and FK_JOB = '{8BDDED49-8509-48C1-A169-B7E68A74C230}' ROWS 1) Cheers Rob On 16

Re: [firebird-support] Need Speed Optimization for SQL

I tried with below SQL, but it is also taking 5 seconds, SELECT   Sum(CRM_DOCUMENT_ITEMS.QUANTITY) AS Delivered,   CRM_DOCUMENT_ITEMS.FK_JOB_ITEM FROM   CRM_DOCUMENT_ITEMS   INNER JOIN CRM_DOCUMENT_HEADER ON CRM_DOCUMENT_ITEMS.FK_DOCUMENT_HEADER = CRM_DOCUMENT_HEADER.PK_DOCUMENT_HEADER WHERE   

[firebird-support] Need Speed Optimization for SQL

Hi All, I have below SQL and DDL of respective columns used in this SQL. Below sql takes 6-7 seconds to give the result. Would it be possible to bring the output time to 1 seconds, coz there are some other operartion I need to perform based on this sql output withing short period of time. SQL:

[firebird-support] trying to change psw

Hello ;) I want to know, how to change the default psw 'masterkey' I'm useing Flame Robin. Inside the app. i go to 'server' option in menu, then 'manage users' The programm ask me for a psw, and i fill it with 'masterkey' But i get an error number 335544721 "UNABLE TO COMPLETE NETWORK

[firebird-support] IBReplicator way to force conflicts

Hi everybody! Are there a way to force all conflicts programmatically? Thank you, Rodrigo Cardoso ++ Visit http://www.firebirdsql.org and click the Docu

Re: [firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit

15.04.2015 22:06, Mark Rotteveel wrote: > Isn't it a bug that it ignores the setting? I'd rather call it a design pitfall, as GTT cannot be splitted among multiple directories. Maybe we could just use the first entry from the list and ignore others. Anyway, it's already registered: http://tra

Re: [firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit

Isn't it a bug that it ignores the setting? Mark - Reply message - Van: "Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]" Aan: Onderwerp: [firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit Datum: wo, apr. 15, 2015 19:47 15.04.2015 20:44, Dmitry Yemanov wrote:

Re: [firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit

Thank you, very good to know. 14.04.2015 18:56, Trond tro-d...@online.no [firebird-support] wrote: The environment variables are as follow TEMP and TMP is F:\TEMP and FIREBIRD_TMP is F:\TEMP;C:\UTVIKLING\TEMP Temporary directories in firebird.conf are all commented out. TempDirectories in

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

---In firebird-support@yahoogroups.com, wrote : Re: [firebird-support] Re: Plan question, what is a stream and what isn't? Note, stored procedures and triggers are prepared\optimized once when loaded into metadata cache. Regards, Vlad > Just by curiosity, when are SPs/Triggers loaded

[firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit

15.04.2015 20:44, Dmitry Yemanov wrote: > TempDirectories always takes precedence over [almost] everything else. > If empty, FIREBIRD_TMP is used. If empty, system TMP/TEMP is used. Re. [almost] above - the only exception is GTTs, they ignore TempDirectories. All other temp usage (sorts, temp bl

[firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit

15.04.2015 16:31, Edward Mendez wrote: > > I always wondered about that. If I have set in my “firebird.conf” a > list of directories, but my FIREBIRD_TMP environment variable has one, > do you know if one setting take precedence over the other? TempDirectories always takes precedence over [almost

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

[firebird-support] Re: Plan question, what is a stream and what isn't?

> ---In firebird-support@yahoogroups.com, wrote : > > If SET STATISTICS is done on one connection, when does it take effect? As any DDL statement it actually runs at transaction commit. > What about a transaction that was already running at the time someone > else did SET STATISTICS, does

Re: [firebird-support] Firebird Roadmap: v3.0 - what's next?

> …many thanks; that’s what I was looking for! So there’s a great many work > under way, but it looks to me that v3 and v4 are currently more or less > optimizations / enhancements and no major changes coming up, right? What are major changes from your perspective? Fine-grained SMP with a share

RE: [firebird-support] Re: Problem with GTT, Firebird 2.5.4 64 bit

Dmitry, I always wondered about that. If I have set in my “firebird.conf” a list of directories, but my FIREBIRD_TMP environment variable has one, do you know if one setting take precedence over the other? Thank you, -Edward Mendez From: firebird-support@yahoogroups.com [mailto:

Re: [firebird-support] Internal Transaction in Fb 2.5.4 Trace Log

If you execute transaction.commitretaining the transaction counter increases but no new transaction is created, then you don't see that number in the log. Jesus Angel Garcia Zarco Cointec > El 15/4/2015, a las 9:50, hannu.laurikai...@yahoo.com [firebird-support] > escribió: > > I executed my

Re: [firebird-support] Firebird Roadmap: v3.0 - what's next?

Take a look at this: https://www.youtube.com/watch?v=ibZKgmHz9_4&feature=youtu.be []s Carlos H. Cantu www.FireBase.com.br - www.firebirdnews.org www.warmboot.com.br - blog.firebase.com.br SCMSmsscdf> …many thanks; that’s what I was looking for! So there’s a SCMSmsscdf> great many work under way,

Re: [firebird-support] Table Relationship Tools

Sparx Systems „Enterprise Architect“ [1] would be one commercial tool fitting your purpose; depending on your use case it might be a little bit „over sized“ but they have got a free trial version, too. __ [1] http://www.sparxsystems.com/products/ea/ > Am 15.04.2015 um 13:17 schrieb Vi

Re: [firebird-support] Firebird Roadmap: v3.0 - what's next?

…many thanks; that’s what I was looking for! So there’s a great many work under way, but it looks to me that v3 and v4 are currently more or less optimizations / enhancements and no major changes coming up, right? > Am 15.04.2015 um 09:25 schrieb Gabor Boros gaborbo...@yahoo.com > [firebird-su

Re: [firebird-support] Table Relationship Tools

Thank You Martijn. Anybody knows any other tools for the same purpose? On Wednesday, 15 April 2015 2:55 PM, "'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]" wrote:   Hello Vishal, >Is there any tool available which would show the relationship/l

[firebird-support] Re: When does SET STATISTICS take effect?

On 14/04/2015 11:39, Tim Ward wrote: If SET STATISTICS is done on one connection, when does it take effect? What about a transaction that was already running at the time someone else did SET STATISTICS, does that use the new statistics for any new statements it runs (where all the code running

[firebird-support] Internal Transaction in Fb 2.5.4 Trace Log

I executed my application which uses a Fb database. Trace log was enabled. There was a strange internal transaction 2015-04-14T10:46:44.6010 (3684:00D0A9F4) START_TRANSACTION C:\. . .\MYDATABASE.FDB (ATT_0, , NONE, ) (TRA_595, READ_COMMITTED | REC_VERSION | WAIT | READ_ONLY) It s

Re: [firebird-support] Table Relationship Tools

Hello Vishal, >Is there any tool available which would show the relationship/linking >between tables for Firebird database ? Our "Database Workbench" tool does that. http://www.upscene.com/documentation/dbw5/dia_pdm_reverse_engineering.htm With regards, Martijn Tonies Upscene Productions http

[firebird-support] Table Relationship Tools

Hi All, Is there any tool available which would show the relationship/linking between tables for Firebird database ? Thanks In Advance. With Best Regards. Vishal

Re: [firebird-support] Firebird Roadmap: v3.0 - what's next?

2015.04.15. 8:58 keltezéssel, Schwarze Consulting - Michael Schwarze michael.schwa...@schwarze-consulting.de [firebird-support] írta: > Hi, > > Just out of curiosity: what’s coming after Firebird v3.0? I checked the > upcoming roadmap [1] and was wondering whether there might be any NoSQL > idea