Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
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 about 20% slower than Linux Mint. I will avoid Windows and use Linux for firebird if it is possible. Regards, Anto.
Re: [firebird-support] query Integer overflow
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 IIF and decide at which moment you need round intermediate values. Then cast the values to types with smaller precision. -- 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
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. ++ 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] query Integer overflow
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 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 IN TEGER) /(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 You can also cast intermediate results to the desired (or sufficient) scale b.PR_EAT_T-b.PR_EAT_T* cast(b.P_TV_E /(100+b.P_TV_E) as numeric(18,2)) etc... -- Mark Rotteveel
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
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 without restart of the computer. If file cached worked, then there is something else that make Firebird runs slower on Windows 10. Windows 10 is a desktop OS, and it demonstrates slowness in so many cases, caused by so many reasons, so I would not use it as a server, until there is no other choice. I personally experienced slowness on one of my own desktops, and perfect performance on the another one. Better just stay out from this lottery. Try to make experiments with Windows Server, it will make more sense. Regards, Alexey Kovyazin IBSurgeon Anto
Re: [firebird-support] query Integer overflow
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* IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T * CAST > (b.P_TV_E AS IN TEGER) /(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 You can also cast intermediate results to the desired (or sufficient) scale b.PR_EAT_T-b.PR_EAT_T* cast(b.P_TV_E /(100+b.P_TV_E) as numeric(18,2)) etc... -- Mark Rotteveel
Re: [firebird-support] Firebird 3.0 performance, Windows 10 vs Mint, big different
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 that make > Firebird runs slower on Windows 10. It is worth reading this: http://dyemanov.blogspot.com/2012/03/firebird-vs-windows-file-system-caching.html Helen --- This email has been checked for viruses by AVG. https://www.avg.com