Skip to main content

FAQs

1. The PawSQL performance verification shows decreased performance after optimization. Are the optimization suggestions still meaningful?​

According to our statistics, over 85% of the SQL performance optimization cases with PawSQL's optimization suggestions can improve SQL query performance, only about 15% show decreased performance.

The reasons for the 15% decreased performance based on our statistics are:

  • 80% - The data volume in the verification environment is too small and the SQL execution time is too short, leading to amplified fluctuations.
  • 10% - Flaws in the database optimizer resulting in PawSQL providing more possibilities for the optimizer to generate execution plans, but the optimizer chose a less efficient one.
  • 10% - PawSQL's illogical computation logic for performance improvement or unreasonable suggestions.

Ideally, performance optimization verification should be conducted on production data. However, due to security concerns, SQL performance optimization is usually performed in a test environment. If the test data in the test environment is very small, especially when the performance verification shows decreased performance, users need to manually judge whether PawSQL's optimization suggestions are reasonable.

2. Private deployment of PawSQL Cloud​

Private deployment is charged software for enterprises, not provided for individuals for free.

PawSQL Products

3. PawSQL's charging model​

PawSQL provides two versions of tools for individual users. One is the Jetbrains IDE plugin, which is charged mainly for overseas users. The other one is the SaaS-based PawSQL Cloud, which is free for individual users.

For enterprise users, we provide private deployment solutions for PawSQL, which is charged.

4. Comparison between PawSQL and EverSQL​

In terms of functionality, the two tools are highly similar in core functions like query rewriting and index recommendations. EverSQL is more user-friendly with better UI designs while PawSQL also provides some functions EverSQL does not have like performance verification and comparison of execution plans.

In terms of charging model, EverSQL free version allows only one optimization per month, while its enterprise version allows 75 optimizations per month. PawSQL allows 90 optimizations per month for every individual user. PawSQL's main business model relies on charging fees for enterprise private deployment.

Please refer to "EverSQL to the left, PawSQL to the right" for more specific differences between them.

5. Why does the PawSQL plugin not use DataGrip's current connection? This way there would be no need to specify in the configuration page.​

DataGrip is just one of the many IDEs users can install PawSQL on, not even the one where most PawSQL installations happen(the most popular one is IDEA Ultimate). Except for DataGrip, other plugins do not have the current connection function. To be compatible with non-DataGrip development tools, PawSQL provides a unified data source configuration page.

info

Downloads distribution of IDEs in JetBrains market

Downloads distribution of IDEs in JetBrains market

6. Why use SID instead of Service Name when connecting to Oracle databases?​

Old versions of Oracle did not have the Service Name. The Service Name concept was introduced in Oracle 8i. So before PawSQL version 2024.1.4, connecting to Oracle databases requires inputting the SID. Starting from PawSQL 2024.1.4, SID will no longer be supported, only Service Name is supported.