Re: [firebird-support] query Integer overflow

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*  IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T   *  CAST (b.P_TV_E AS INTEGER)   /(100+   CAST (b.P_TV_E AS

Re: [firebird-support] query Integer overflow

The calculation is on a SP code and I need it there,worked for couple years..until that valuesthanks On Sunday, June 23, 2019, 12:42:42 AM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-support]

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

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 that make Firebird runs

Re: [firebird-support] How to know if FileSystemCacheThreshold works?

Hello, Thanks for the replied. I have downloaded new RAMMap ver 1.52 and it work on Windows 10. On Process tab of RAMMap, firebird.exe took 2,183,484K. On File details tab, database file took 2,603,168K. Does it means, FileCached worked? It if worked, how come, the disk kept spinning when

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

Thanks for the info. I downloaded ver 1.52, now it works. As I expected, on Windows 10, File System Cached doesn't work. Discussion continue here, as it is a related topic https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/134237

Re: [firebird-support] query Integer overflow

22.06.2019 21:47, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64 My advice is "never perform calculations (especially multiplication and division) in SQL". Your expression has result of type NUMERIC(18,14)

Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

RAMMap 1.51 works fine with Windows 10. Carlos Migration Guide to Firebird 3 http://www.firebirdnews.org/migration-guide-to-firebird-3/ tycfs> Hi guys, tycfs> I compared firebird 3 SS performance in windows 10 pro 64 vs tycfs> Linux mint 19.1 cinnamon 64 bit. tycfs> Both OS use the same

[firebird-support] query Integer overflow

HiI'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64: Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.Integer overflow.  The result of an integer operation caused the most significant bit of the result to

[firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different

Hi guys, I compared firebird 3 SS performance in windows 10 pro 64 vs Linux mint 19.1 cinnamon 64 bit. Both OS use the same database configurations & almost the same speed ssd. Windows use a bit faster ssd. On windows 10, I have turn off everything than can be turn off, such as bloat ware,

Re: [firebird-support] How to know if FileSystemCacheThreshold works?

Thanks for your reply. Unfortunately, RAMMap don't work in Windows 10.

Re: [firebird-support] How to know if FileSystemCacheThreshold works?

Hello, Download RAMMap from Sysinternals (Micorosft), and see if database file is in list of cached files. Regards, Alexey Kovyazin IBSurgeon On 22.06.2019 11:42, trsk...@yahoo.com [firebird-support] wrote: Hi guys, I have FB 3.04 SS in windows 10. I have a database with these setting on

[firebird-support] How to know if FileSystemCacheThreshold works?

Hi guys, I have FB 3.04 SS in windows 10. I have a database with these setting on database.conf my_dba = C:\Dba\db.fdb { FileSystemCacheThreshold = 393216 LockMemSize = 16M LockHashSlots = 30011 TempCacheLimit = 2048M TempBlockSize = 2M FileSystemCacheSize = 50 }