{"id":69412,"date":"2021-08-20T14:23:02","date_gmt":"2021-08-20T18:23:02","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/comparison-firebird-mysql-postgresql-2\/"},"modified":"2021-08-20T14:23:02","modified_gmt":"2021-08-20T18:23:02","slug":"comparison-firebird-mysql-postgresql-2","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69412","title":{"rendered":"Comparison: FireBird, MySQL, PostGreSQL #2"},"content":{"rendered":"<p>PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.<br \/>http:\/\/benchw.sourceforge.net\/benchw_results_open3.html<\/p>\n<p>Several PostGreSQL versions are compared at:<br \/>http:\/\/benchw.sourceforge.net\/benchw_results_postgres_history.html<\/p>\n<p>Several MySQL versions are compared at:<br \/>http:\/\/benchw.sourceforge.net\/benchw_results_mysql_indexes.html<\/p>\n<hr \/>\n<p>A good comparison among these databases will be found at:http:\/\/www.geocities.com\/mailsoftware42\/db\/<\/p>\n<hr \/>\n<hr \/>\n<p>Mentionable comments<\/p>\n<p>PostGreSQL Supports 400+GB DB.One source: As for each connection it forks new thread, it is bit slower than MySql: Another source: postgresql is faster than mysql. Seems the truth is: for single connection postgresql can be faster but for multiple connections mysql is faster. just an information, not sure yet.<\/p>\n<h2>New PostGre Features<\/h2>\n<p>http:\/\/www.postgresql.org\/docs\/whatsnewSome mentionable comments: Supports SMP and almost linearly improves performance witth multiprocessor system.<\/p>\n<p>Supports roles, in\/out parameters\/two phase commit\/table partitioning shared row locking(firebird record level locking), 64 bit shared memory hence supports two terabytes of ram<\/p>\n<p>PostGreSQL capability4.4) What is the maximum size for a row, a table, and a database?These are the limits:<br \/>Maximum size for a database? unlimited (32 TB databases exist) <br \/>Maximum size for a table? 32 TB <br \/>Maximum size for a row? 400 GB <br \/>Maximum size for a field? 1 GB <br \/>Maximum number of rows in a table? unlimited <br \/>Maximum number of columns in a table? 250-1600 depending on column types <br \/>Maximum number of indexes on a table? unlimited <br \/>One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are rarely needed. Uniqueness is best guaranteed by a function index of an MD5 hash of the long column, and full text indexing allows for searching of words within the column.Source:http:\/\/www.postgresql.org\/docs\/faqs.FAQ.html4.20) What replication solutions are available? Though &#8220;replication&#8221; is a single term, there are several technologies for doing replication, with advantages and disadvantages for each.<br \/>Master\/slave replication allows a single master to receive read\/write queries, while slaves can only accept read\/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I.<br \/>Multi-master replication allows read\/write queries to be sent to multiple replicated computers. This capability also has a severe impact on performance due to the need to synchronize changes between servers. PGCluster is the most popular such solution freely available for PostgreSQL.<br \/>There are also commercial and hardware-based replication solutions available supporting a variety of replication models.<\/p>\n<h2>Important Notes<\/h2>\n<p>Server Configuration A number of postgresql.conf settings affect performance. For more details, see Administration Guide\/Server Run-time Environment\/Run-time Configuration for a full listing, and for commentary see http:\/\/www.varlena.com\/varlena\/GeneralBits\/Tidbits\/annotated_conf_e.html and http:\/\/www.varlena.com\/varlena\/GeneralBits\/Tidbits\/perf.html. <br \/>Hardware Selection <br \/>The effect of hardware on performance is detailed in http:\/\/www.powerpostgresql.com\/PerfList\/ and http:\/\/momjian.us\/main\/writings\/pgsql\/hw_performance\/index.html. <\/p>\n<h1>Wikipedia link for postgressql-<a href='http:\/\/en.wikipedia.org\/wiki\/PostgreSQL'>http:\/\/en.wikipedia.org\/wiki\/PostgreSQL<\/a><\/h1>\n<p>EnterpriseDB kind of commercial but cheap based on postgressql <br \/> From: http:\/\/sitestree.com\/?p=4712<br \/> Categories:2<br \/>Tags:<br \/> Post Data:2010-01-24 02:30:40<\/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>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 source: As for each connection &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69412\">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-69412","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":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":69412,"position":0},"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":69412,"position":1},"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":69422,"url":"http:\/\/bangla.sitestree.com\/?p=69422","url_meta":{"origin":69412,"position":2},"title":"Speed: Firebird vs. PostGreSql #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"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.\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":24463,"url":"http:\/\/bangla.sitestree.com\/?p=24463","url_meta":{"origin":69412,"position":3},"title":"Java Spring: Components to Deal with Database (SQL Aspect) #Root","author":"Author-Check- Article-or-Video","date":"April 10, 2021","format":false,"excerpt":"Java Spring: Components to Deal with Database (SQL Aspect) JPA: Java Persistence API including spring-data-jpa, spring-orm and Hibernate JOOQ: Persistence support using Java Object Oriented Querying MyBatis: Persistence support using MyBatis JDBC: JDBC databases H2: H2 database (with embedded support) HSQLDB: HSQLDB database (with embedded support) Apache Derby: Apache Derby\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":69412,"position":4},"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":[]},{"id":14422,"url":"http:\/\/bangla.sitestree.com\/?p=14422","url_meta":{"origin":69412,"position":5},"title":"Optimizing PostgreSQL on AWS","author":"Sayed","date":"August 20, 2018","format":false,"excerpt":"AWS Online Tech Talk. Webinar: Optimizing PostgreSQL on AWS Recording Presentation slides","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69412","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=69412"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69412\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69412"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}