[GitHub] [incubator-superset] SyamprasadNakka commented on issue #8548: Dashboard results are very slow when pointed to Postgres Database

[GitBox <gi...@apache.org>]

SyamprasadNakka commented on issue #8548: Dashboard results are very slow when pointed to Postgres Database
URL: https://github.com/apache/incubator-superset/issues/8548#issuecomment-553339478
 
 
   Hi @dpgaspar ,
   
   
   > 
   > 
   > Hi @SyamprasadNakka,
   > 
   > I'm not totally understanding your issue. First to clarify, `SQLALCHEMY_DATABASE_URI` configures the connection string for superset's metadata DB.
   > 
   > Have you changed the metadata DB from Oracle to PG?
   
   We have changed SQLALCHEMY_DATABASE_URI = 'postgresql://superset:superset@localhost/superset' in config.py to point Postgres database for metadata and running the server.
   
   After we installed cx_oracle module and creating reports through the Oracle database connection as below.
   1. Create Oracle database Connection: Sources --> Databases --> SQLAlchemy URI = oracle://username:password@hostname:port/SID 
   2. RUN Query: SQL Lab --> SQL Editor --> execute query --> Explore.
   3. Save Report: Explore --> Save report.
   4. Pull the reports on to Dashboards.
   
   After pulling the reports on to dashboards the results are getting very slow and taking 50 sec to load.
   
   Kindly let me know if any questions.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org