On Feb 9, 2015, at 11:52 AM, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] firebird-support@yahoogroups.com wrote:
What is your cache settings
[2048]
Zoran's complaint is about the first time the query is executed. In that
case, nothing would be in cache and
Ann,
Zoran's complaint is about the first time the query is executed. In that
case, nothing would be in cache and everything would still need to be loaded
from disk.
A 2048 page cache may be small enough that it would cause problems even
during loading, given the size of his database and
I am having similar issues. Are there any resources to read up on this?
What do you mean by similar issues, Louis? Zoran first showed us his SQL and
plan, so that we more or less could see that his SQL, plan and indexes seemed
good (that's arguably the most common reason for speed problems).
: firebird-support@yahoogroups.com firebird-support@yahoogroups.com
Temat: [firebird-support] Re: Speed issues
Data: pon., lut 9, 2015 16:52
Karol,
What is your cache settings
In this case, the answer won't really matter.
Zoran's complaint is about the first time the query is executed
Thanks Sean for all your comments.
Zoran
in due course.
Thanks for the response Set
Louis
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 09 February 2015 12:00 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: Speed issues
I am having similar issues
I am doing restore now with 8192 page value, but I will not know before
tomorrow. It will not be finishen in next 90 minutes, and I all be sleeping
until tehn, probably.
Thanks for your advices - I will advice tomorow about changes.
Also, what do you think - when I put it on working server -