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 INTEGER) ), b.PR_I) FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc 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] 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) and result of calculation is bigger than . -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
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] 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) and result of calculation is bigger than . -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
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 slower on Windows 10. Anto
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 query runs? Thanks & regards, Anto.
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 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) and result of calculation is bigger than . -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
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 database configurations & almost the same tycfs> speed ssd. Windows use a bit faster ssd. tycfs> On windows 10, I have turn off everything than can be turn tycfs> off, such as bloat ware, unnecessary services, background applications, etc. tycfs> Database page buffer set to 131072, and page size set to tycfs> 16384. Both OS have 16GB RAM. File cached threshold, set to 384000. tycfs> Run query a few times via flamerobin, the results were, tycfs> Firebird run faster on Mint, at least 20% faster, that was a big different. tycfs> Don't know why on windows the performance was bad. Perhaps on tycfs> windows 10, file cached didn't work, cause I saw the disk kept spinning while query ran. tycfs> This is strange, on Windows 7, with the same database tycfs> configuration, firebird took about 5GB RAM, which means that file cached work fine. tycfs> Couldn't inspect actual RAM usage on windows 10 cause RAMMap doesn't work. tycfs> tycfs> Posted by: trsk...@yahoo.com tycfs> tycfs> ++ tycfs> Visit http://www.firebirdsql.org and click the Documentation item tycfs> on the main (top) menu. Try FAQ and other links from the left-side menu there. tycfs> Also search the knowledgebases at tycfs> http://www.ibphoenix.com/resources/documents/ tycfs> ++ tycfs> tycfs> Yahoo Groups Links
[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 carry. on this query SELECT b.cant* IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T* b.P_TV_E /(100+b.P_TV_E), b.PR_I) FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc cant NUMERIC(15,4) PR_EAT_T NUMERIC(16,4) P_TV_E NUMERIC (9,2) PR_I NUMERIC(16,4) I have 2 records with same values: cant =5993.3160 PR_EAT_T=0. P_TV_E=0.00 PR_I= 1580.3472 thanks
[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, unnecessary services, background applications, etc. Database page buffer set to 131072, and page size set to 16384. Both OS have 16GB RAM. File cached threshold, set to 384000. Run query a few times via flamerobin, the results were, Firebird run faster on Mint, at least 20% faster, that was a big different. Don't know why on windows the performance was bad. Perhaps on windows 10, file cached didn't work, cause I saw the disk kept spinning while query ran. This is strange, on Windows 7, with the same database configuration, firebird took about 5GB RAM, which means that file cached work fine. Couldn't inspect actual RAM usage on windows 10 cause RAMMap doesn't work.
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 database.conf my_dba = C:\Dba\db.fdb { FileSystemCacheThreshold = 393216 LockMemSize = 16M LockHashSlots = 30011 TempCacheLimit = 2048M TempBlockSize = 2M FileSystemCacheSize = 50 } Database page size : 16834 Database pagebuffers : 131072 Size of database file is about 8GB. Total Windows RAM, 16GB, free RAM, more than 8GB. I run the same query via flamerobin about three time, then looked on WIndows Task Manager and each time the query was running, the disk kept spinning. Does it means that Firebird's FileSystemCache doesn't works? How to know if it works? Thanks in advance.
[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 } Database page size : 16834 Database pagebuffers : 131072 Size of database file is about 8GB. Total Windows RAM, 16GB, free RAM, more than 8GB. I run the same query via flamerobin about three time, then looked on WIndows Task Manager and each time the query was running, the disk kept spinning. Does it means that Firebird's FileSystemCache doesn't works? How to know if it works? Thanks in advance.