tag:blogger.com,1999:blog-3568892889704760508.comments2023-04-12T15:58:27.424+02:00Firebird: Under the HoodDmitry Yemanovhttp://www.blogger.com/profile/09711564106003431793noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-3568892889704760508.post-50772511893435017932015-07-29T18:30:48.112+02:002015-07-29T18:30:48.112+02:00It's a source code flag, it was removed starti...It's a source code flag, it was removed starting with Firebird 2.1.5 and 2.5.2.Dmitry Yemanovhttps://www.blogger.com/profile/09711564106003431793noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-45631624382930057862015-07-29T18:21:22.791+02:002015-07-29T18:21:22.791+02:00Ok. How I can remove the FILE_FLAG_RANDOM_ACCESS f...Ok. How I can remove the FILE_FLAG_RANDOM_ACCESS flag?<br />It's a configuration of windows (2012 in this case) or the file .fdb?Flávio Kleinhttps://www.blogger.com/profile/00817968969128262924noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-90972454786877532182013-02-28T18:56:47.795+03:002013-02-28T18:56:47.795+03:00Firebird actually uses Named Pipes which are a par...Firebird actually uses Named Pipes which are a part of the Windows API and thus unlikely to be dropped ever. They could be built on top of NetBEUI or natively over TCP, it's just an implementation detail. So in fact this doesn't change anything for Firebird.Dmitry Yemanovhttps://www.blogger.com/profile/09711564106003431793noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-19843739693462980282013-02-28T18:22:02.022+03:002013-02-28T18:22:02.022+03:00NetBEUI isn't dropped from WindowsXP ? i guess...NetBEUI isn't dropped from WindowsXP ? i guess it can be deleted in the Firebird 3.x <br /><br />http://support.microsoft.com/kb/306059Popa Adrian Mariushttps://www.blogger.com/profile/09862886782232467681noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-52942699465705159232012-08-21T19:18:01.130+03:002012-08-21T19:18:01.130+03:00I understand, but I really think you had the knowl...I understand, but I really think you had the knowledge and many tests could shorten giving me some tips. Likewise, thanks.Helder Velosohttps://www.blogger.com/profile/05477638921612617718noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-61296221537729273902012-08-21T18:33:15.995+03:002012-08-21T18:33:15.995+03:00This blog is not intended for support, sorry. You ...This blog is not intended for support, sorry. You may find the appropriate support resources here:<br />http://www.firebirdsql.org/en/support/Dmitry Yemanovhttps://www.blogger.com/profile/09711564106003431793noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-37866290873095065542012-08-21T18:28:00.032+03:002012-08-21T18:28:00.032+03:00Mr Dmitry,
Please help me, I am actually reading ...Mr Dmitry,<br /><br />Please help me, I am actually reading your blog about the situation with low speed of firebird in some cases, my situation is an IBM SERVER X3400 M3 with one database approx 5GB, running in Windows Server 2003 R2 Enterprise with PAE for 8GB RAM RDIMM DDR3, 40 simultaneous access. Could async writes solve my problem? The disk read/writes are very high, the raid controller have 256mb of cache.<br /><br />Thank You. Best RegardsHelder Velosohttps://www.blogger.com/profile/05477638921612617718noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-13795620162522001112012-07-15T07:50:59.578+03:002012-07-15T07:50:59.578+03:00So, how can we use this solution on FB2.5.1 x32 on...So, how can we use this solution on FB2.5.1 x32 on Windows 2003R2 x64? <br />Do we need upgrade to 2.5.2 beta?Anonymoushttps://www.blogger.com/profile/02194925591252641584noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-16378274089117763012012-07-13T18:41:23.132+03:002012-07-13T18:41:23.132+03:00As far as I know, once Windows becomes a DC, it fo...As far as I know, once Windows becomes a DC, it forces the disk write-through cache to be turned off and you cannot turn it on manually. It makes any disk writes noticeably slower. If you use synchronous writes in your Firebird database (FW=ON), it will slow down your application a lot. With async writes (FW=OFF) the situation should be much better, more or less matching PostgreSQL. Generally speaking, using a DC for a database server is not a good idea if you care about both performance and reliability.Dmitry Yemanovhttps://www.blogger.com/profile/09711564106003431793noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-5510872596028079962012-07-13T15:06:51.890+03:002012-07-13T15:06:51.890+03:00Hi Dmitry,
I'm having serious performance loss...Hi Dmitry,<br />I'm having serious performance loss problems using firebird installed in a Windows Server 2008 promoted to domain controller. I don't know if this problem has to do with this topic, but I search every forum I could find and did not found a solution.<br />When I install firebird in windows 7 or windows server 2008 without being the domain controller, queries run very fast, as should be. But if I promote windows server 2008 to domain controller, it becomes 10-50 times slower. <br />I made a test application that create a table and make 5000 inserts, a select of all this records, followed several updates and deletes. It normally takes 30 to 40 seconds to do everything in windows 7 or windows server 2008 without domain. After the domain promotion, the time go for almost 6 minutes! Curiously, if I demote the domain it continues to be slow. I need to format the computer and install Windows again, then it becomes fast again. <br />I use delphi, and made several tests, using IB components and dbExpress drivers, to see if were anything related to the drivers, but the result is the same. <br />I also made the same test with postgresql, and it worked fine, with no problems, with or without the domain. But I use firebird in all of my applications, and I don't want to migrate to postgresql right now.<br />I'm looking for help, and I think that you could be the most capable person on earth to help me with this problem.<br />If you have a little time to look into it, I can send my test application, and you can see the problem. I also can send my application results, if needed.<br />Please, help us with this matter.<br />Thanks<br />Tiago.Anonymoushttps://www.blogger.com/profile/05767411530880155742noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-22251941305700588612012-04-04T16:52:31.332+03:002012-04-04T16:52:31.332+03:00Obviously --you-- saved my life. Sorry for the typ...Obviously --you-- saved my life. Sorry for the typo (and presumption) :-)gustavohttps://www.blogger.com/profile/05553411937793097827noreply@blogger.comtag:blogger.com,1999:blog-3568892889704760508.post-19578713211522496872012-04-02T17:54:45.109+03:002012-04-02T17:54:45.109+03:00Hi Dmitry,
I just saved my life now as I´m having...Hi Dmitry,<br /><br />I just saved my life now as I´m having a lot of trouble with this issue. I run a 30GB db in a 16GB box and when all the memory is full, my app server that runs in the same box simply crashes without a reason. I have other reports that this app server stops working in the morning, coincidentally after gbak runs. <br /><br />Many thanks for this fix!gustavohttps://www.blogger.com/profile/05553411937793097827noreply@blogger.com