Does it mean that adding necessary indexes will save me time in the future and
make me slower on new inserts now?
Or, does it take more than indexes for fine query performance even in large
data tables?
Sent from my iPhone
> On 21 Jan 2016, at 19:08, liviusliv...@poczta.onet.pl [firebird-suppo
Hi,
as you can see in query plan – you have natural (full table scan).
And hash match you see in MSSQL “because” you have not optimized query.
Your query use a lot of RAM and CPU to return value. MSSQL built hash table and
join streams.
But this query will be slower and slower if your table wil
Hello,
I will created indexes necessary. However, I think I cannot do anything about
Hash match. Is it making Firebird slower Hash match? I don't know what is Hash
match anyway.
Thanks.
Ertan Küçükoğlu
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: T
On Thu, 21 Jan 2016 10:44:10 +, "Tim Ward t...@telensa.com
[firebird-support]" wrote:
> I've got a long running (hours) PHP script which does large numbers
> (tens of thousands) of database operations along the lines of
>
> start explicit transaction
> do something in that transact
hi,
this is what i supposed. Hash match. And as Arno Brinkman say you have not
defined indexes on filtered columns
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"
Data: 21.01.2016 00:18 (GMT+01:00)
I've got a long running (hours) PHP script which does large numbers
(tens of thousands) of database operations along the lines of
start explicit transaction
do something in that transaction
commit that transaction
the idea being not to hold any individual transaction open for a lo