Re: [firebird-support] Doubt in Firebird

2016-05-18 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello lionel, Thursday, May 19, 2016, 12:50:44 AM, you wrote: > I use firebird 2.5.6.I just wanted to know if there is a method by > which i can speed > an insert query to (insert about 5 records) into a table.Right now it is > taking about > 40 minutes.My front end is VBscript

[firebird-support] Doubt in Firebird

2016-05-18 Thread lionel napoleon lionelnapol...@yahoo.com [firebird-support]
Hi,         I use firebird 2.5.6.I just wanted to know if there is a method by which i can speedan insert query to (insert about 5 records) into a table.Right now it is taking about 40 minutes.My front end is VBscript and i use a prepared statement.Any help would be 

Re: [firebird-support] Minimal file file requirements for FB3 (client/embedded)

2016-05-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 17-5-2016 18:08, josef.gschwendt...@quattro-soft.de [firebird-support] wrote: > could please anybody tell us which files we definitely have to ship with > our app as client for a FB3 remote server or as an FB3 embedded server? > (minimal files required). > > Standard Client: > - fbclient.dll

Re: [firebird-support] Full outer join poor performance.

2016-05-18 Thread agharta aghart...@gmail.com [firebird-support]
On 05/18/2016 09:03 AM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, as mentioned by other - this is because of outer join look at: http://tracker.firebirdsql.org/browse/CORE-4823 regards, Karol Bieniaszewski W dniu 2016-05-17 12:20:42 użytkownik agharta

Re: [firebird-support] Full outer join poor performance.

2016-05-18 Thread agharta aghart...@gmail.com [firebird-support]
On 05/17/2016 09:52 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 17.05.2016 12:20, agharta aghart...@gmail.com [firebird-support] wrote: >> Any ideas about why fb take too long time to execute the query (and >> scans so mutch rows)? > PG can do hash full outer join,

Re: [firebird-support] Full outer join poor performance.

2016-05-18 Thread agharta aghart...@gmail.com [firebird-support]
On 05/17/2016 10:51 PM, setysvar setys...@gmail.com [firebird-support] wrote: Den 17.05.2016 12:20, skrev agharta aghart...@gmail.com [firebird-support]: > Hi all, this is my first post and my english is bad, please be patient :-) > > I've a problem with a full outer join, let me explain. >

Re: [firebird-support] Full outer join poor performance.

2016-05-18 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   as mentioned by other - this is because of outer join look at: http://tracker.firebirdsql.org/browse/CORE-4823   regards, Karol Bieniaszewski   W dniu 2016-05-17 12:20:42 użytkownik agharta aghart...@gmail.com [firebird-support] napisał:   Hi all, this is