Hey Gordan, Got you.. I actually have a script that can translate the relevant tables for the benchmark test In mind but have yet to sit on it. I really do not have any intention of replacing the DB but merely try to understand if this similar issue in the query optimizer present in most of the popular DB systems. I do assume that Oracle DB do not have an issue since I have seen it does a much more complex queries on a very large data sets pretty easily, however there is a difference between what I believe to what I know when I am trying to state that there is a bug in any DB what so ever and whatever the depth of this bug. Since MySQL and MaraiDB have the same roots and both have this exact same optimization bug I just wanted to verify. Thanks, Eliezer * I will try to update here on whatever steps I will take in the near future ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: ngtech1ltd@gmail.com Web: https://ngtech.co.il/ My-Tube: https://tube.ngtech.co.il/ -----Original Message----- From: Gordan Bobic <gordan.bobic@gmail.com> Sent: Tuesday, 26 July 2022 23:16 To: Eliezer Croitoru <ngtech1ltd@gmail.com> Cc: Mailing-List mariadb <maria-discuss@lists.launchpad.net> Subject: Re: [Maria-discuss] Looking for advice where to start looking at a slow query case On Tue, Jul 26, 2022 at 11:04 PM <ngtech1ltd@gmail.com> wrote:
Hey Gordon,
Before I am filing a jira bug report I would like to verify how the same queries are running on other DB ie: * MSSQL * PostgreSQL * Oracle DB
You are probably going to have to ask that question on forums where the primary interest are those respective databases.
Are there any recommended tools to migrate the data from MariaDB to PostgreSQL or MSSQL?
Migrating to completely different databases is not something you can do without a non-trivial amount of effort, unless your application and requirements are pretty trivial. You are going to have to at the very least make changes to your application to address various incompatibilities in the SQL dialects and features.
Specifically MSSQL has a migration tool but I have yet to use it so I am looking for whatever recommendations. Any MariaDB to PostgreSQL transferring tool known to anyone?
In theory, mysqldump has an option for formatting the output so that it is more easy to ingest into other databases. In reality, unless your data and structures are very trivial, you will still have to thump the output to make the ingestion process work.
I can try to re-create the scenario just with the relevant tables and it would be pretty simple to do eventually but time consuming if there is any automated tools for that.
Any Recommendation is more then welcome!
The recommendation I can give you is that if you are looking at migrating to a completely different database just to avoid using an index hint, you probably haven't thought through the complexities of migrating between databases.