{"id":69422,"date":"2021-08-20T14:23:04","date_gmt":"2021-08-20T18:23:04","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/speed-firebird-vs-postgresql-2\/"},"modified":"2021-08-20T14:23:04","modified_gmt":"2021-08-20T18:23:04","slug":"speed-firebird-vs-postgresql-2","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69422","title":{"rendered":"Speed: Firebird vs. PostGreSql #2"},"content":{"rendered":"<p>Please read.According to this article postgresql faster than firebird. But I also got information\/tests where firebird is faster than postgresql.<\/p>\n<p>http:\/\/archives.postgresql.org\/pgsql-advocacy\/2003-06\/msg00280.php<\/p>\n<p>However,  Speed may not be the only factor to select a database product. We can improve raw speed in many alternate ways, hardware solutions, ram, faster storage, faster CPU. To compare speed issue, efficiency issue, we need to take a look how the query optimizations are implemented in databases. How, the joins, inner joins, outer joins are implemented. How multiple joins are implemented. Also, indexing is a factor that also affects performance issue. We can try creating same database and using a queries that are simple to complex and run on both databases and see, how well they perform.<\/p>\n<p>Postgresql   supports SMP (multiple processor system) and provides better efficiency in multiprocessor systems. Firebird, is not still matured in SMP environment.<\/p>\n<p> Firebird supports 32 bit environment, still not stable\/reliable enough for 64 bit env. It supports max ram of 2 gb and hence 150 &#8211;  450 concurrent users. Postgresql supports 2 TB of ram in a single server. For both of them, we can implement multiple servers with master\/slave relation for better performances.<\/p>\n<p>From: http:\/\/sitestree.com\/?p=4718<br \/> Categories:2<br \/>Tags:<br \/> Post Data:2010-10-28 19:53:29<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Please read.According to this article postgresql faster than firebird. But I also got information\/tests where firebird is faster than postgresql. http:\/\/archives.postgresql.org\/pgsql-advocacy\/2003-06\/msg00280.php However, Speed may not be the only factor to select a database product. We can improve raw speed in many alternate ways, hardware solutions, ram, faster storage, faster CPU. To compare speed issue, efficiency &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69422\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69422","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69412,"url":"http:\/\/bangla.sitestree.com\/?p=69412","url_meta":{"origin":69422,"position":0},"title":"Comparison: FireBird, MySQL, PostGreSQL #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.http:\/\/benchw.sourceforge.net\/benchw_results_open3.html Several PostGreSQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_postgres_history.html Several MySQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_mysql_indexes.html A good comparison among these databases will be found at:http:\/\/www.geocities.com\/mailsoftware42\/db\/ Mentionable comments PostGreSQL Supports 400+GB DB.One\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69422,"position":1},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69416,"url":"http:\/\/bangla.sitestree.com\/?p=69416","url_meta":{"origin":69422,"position":2},"title":"Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Firebird and postgresql:http:\/\/www.linuxjournal.com\/node\/7010 Important comment: easy to migrate from oracle to firebird than to postgre or mysql. From interbase to firebird will be better as they are similar. http:\/\/forums.devshed.com\/firebird-sql-development-61\/mysql--vs--firebird-sql-62269.html : Firebird is far better choice than mysqlAs for Performance, MySQL will outperform Firebird on almost all tests on local machine......On\u2026","rel":"","context":"In &quot;C# - Misc&quot;","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69245,"url":"http:\/\/bangla.sitestree.com\/?p=69245","url_meta":{"origin":69422,"position":3},"title":"Database Administration : Random #39","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"Vacuum:vacuum is a useful command to maintain PostGreSql database integrity. Also, it permanently removes deleted database records (by default PostGreSql does not delete permanently). It also rearranges page tables, segments for better performance. vacuum should be run regularly for optimized performance. You can also automate the execution. Syntax: vacuum [FULL|Analyze|Verbose|table\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69326,"url":"http:\/\/bangla.sitestree.com\/?p=69326","url_meta":{"origin":69422,"position":4},"title":"Query Optimization in PostGreSQL #3","author":"Author-Check- Article-or-Video","date":"August 17, 2021","format":false,"excerpt":"check: http:\/\/www.postgresql.org\/docs\/7.3\/interactive\/geqo.html\"optimization effort is caused by the support of a variety of join methods (e.g., nested loop, hash join, merge join in PostgreSQL) to process individual joins and a diversity of indexes (e.g., R-tree, B-tree, hash in PostgreSQL) as access paths for relations. \" \"The current PostgreSQL optimizer implementation performs\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69428,"url":"http:\/\/bangla.sitestree.com\/?p=69428","url_meta":{"origin":69422,"position":5},"title":"Tools to create ER diagrams from a database dynamically #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69422"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69422\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69422"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}