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.
>
> 2 tables (10 rows each), 2 cte, 2 full outer joins, 100 rows output.
> No index
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, FB cannot. That's all.
--
WBR, SD.
-
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.
2 tables (10 rows each), 2 cte, 2 full outer joins, 100 rows output.
No indexes. Execution took about 40s. in postgres (i've do a equal
test comparision)..
17.05.2016 20:05, p...@royston.com [firebird-support] wrote:
>We just recently discovered that our GBAK restore time went from 5 hours
> down to 35
> minutes if we removed LocalHost from the database name on GBAK.
It can be even better if you use switch -se.
--
WBR, SD.
We have a website that has been running over a decade on Firebird, starting
with 1.0.3. Running on Windows, IIS with an ISAPI dll written in Delphi. We
are in the process of upgrading to FB 3.0
Using SuperServer in FB 1 we were required to use LocalHost:DatabaseName
for our connections
Hi,
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
- are there other files needed?
Embedded Server:
- fbclient.dll
- which other files
Thanks Helen for this thorough explanation.
I decided to keep the db running on windows and try to access it from linux.
robert
On 10.05.2016 22:25, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
> Hello robert,
>
> Wednesday, May 11, 2016, 3:47:19 AM, you wrote:
>
>> I got a databa
Hi there,
I try to access a firebird db on windows from my ubuntu box.
I have a gui-tool (FlameRobin), from which this works nicely. Therefore
it is not a firewall or access problem.
Now I would like to do it using python and sqlalchemy.
So far I failed..
This is the connection string I use:
en