Hello,
I have tried to enable LargeSystemCache on Windows 10, no effect.
With or without LargeSystemCache, the second query run on Windows 10 was about
33% faster than the first run, I guest File Cached did work although still saw
disk activity.
But even the second query runs, it was still
thanks for the tip Dimitry
On Sunday, June 23, 2019, 11:38:04 AM GMT+3, Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support] wrote:
23.06.2019 5:41, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> The calculation is on a SP code and I need it there
Then get rid of
23.06.2019 5:41, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
> The calculation is on a SP code and I need it there
Then get rid of IIF and decide at which moment you need round intermediate
values. Then
cast the values to types with smaller precision.
--
WBR, SD.
it is workingthanks
On Sunday, June 23, 2019, 10:00:20 AM GMT+3, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 23-6-2019 05:59, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
>
>
> the error is gone if I cast one of the values as integer (at this
Hello,
Don't know, if this means file cached work or not.
It works.
I recommend to do several experiments with different Pafe buffers and
FileSystemCacheThreshold values (Buffers > FileSystemCacheThreshold ,
Buffers < FileSystemCacheThreshold ), and check RAMMap. Try to do it
with and
On 23-6-2019 05:59, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote:
>
>
> the error is gone if I cast one of the values as integer (at this moment
> there is no decimal needed for that field):
>
>
> CAST (b.P_TV_E AS INTEGER)
> instead of
> b.P_TV_E
>
>
> SELECT b.cant*
Anto wrote:
> Thanks for your info.
> Downloaded ver 1.52, now it worked.
> On Process tab of RAMMap, firebird.exe took 2,183,484K.
> On File details tab, database file took 2,603,168K.
> Don't know, if this means file cached work or not.
> If file cached worked, then there is something else