Help to use no auto rehashing in sqlchemy.

[ashish vicky]

Hello All,

  Can someone help me use no auto rehashing (as what is used in mysql using option -A) using create _engine in sqlalchemy.I want to reduce time in connecting with mysql using sqlalchemy to optimese performance of our application.

Thanks,

Ashish.

[Mike Bayer]

On Mon, Sep 23, 2019, at 2:11 PM, ashish vicky wrote:

Hello All,

  Can someone help me use no auto rehashing (as what is used in mysql using option -A) using create _engine in sqlalchemy.I want to reduce time in connecting with mysql using sqlalchemy to optimese performance of our application.

I looked up what "auto rehashing" is and found:

https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_auto-rehash

this appears to be specific to the "mysql" command line client in that it has autocompletion enabled for table names and such, which has to do with intercepting your typing of characters into the program; this is part of a unix system called "readline".

The situation with a Python database API is completely different in that there is no command line program running and no relevance for something like "readline" or intercepting of characters, so this option does not apply to a Python DBAPI or SQLAlchemy's create_engine.   For example, the native mysqlclient DBAPI defines this API: https://mysqlclient.readthedocs.io/user_guide.html#functions-and-attributes  which does not express any autocompletion concept.

Thanks,

Ashish.

--

SQLAlchemy -

The Python SQL Toolkit and Object Relational Mapper

 

http://www.sqlalchemy.org/

 

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description.

---

You received this message because you are subscribed to the Google Groups "sqlalchemy" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAA%3D86H5y6JjjB-KqzyitE0chRV7GuUbkcEfHcp6sgLshW_dfog%40mail.gmail.com.