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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/CAA%3D86H5y6JjjB-KqzyitE0chRV7GuUbkcEfHcp6sgLshW_dfog%40mail.gmail.com > > <https://groups.google.com/d/msgid/sqlalchemy/CAA%3D86H5y6JjjB-KqzyitE0chRV7GuUbkcEfHcp6sgLshW_dfog%40mail.gmail.com?utm_medium=email&utm_source=footer>. -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/b8dbfc53-8f5f-4ce3-89c9-727293b6fcf8%40www.fastmail.com.