Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
When you extend and optimize the queries in a stored procedure, all the applications that call the procedure automatically receive the benefits. A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-windows-debug.html
The associated Debug files are bundled in its own Zip file, including two lib/ directories: lib/: PDB files to use with regular builds; they are built in RelWithDebInfo mode. Debug/lib/: Debug builds built in Debug mode; includes driver, PDB files, ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
SQLSpecialColumns Yes X/Open Returns information about the optimal set of columns that uniquely identifies a row in a specified table, or the columns that are automatically updated when any value in the row is updated by a transaction. For the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-support-version-history.html
At installation time, you can choose the Unicode driver for the broadest compatibility with data sources using various character sets, or the ANSI driver for optimal performance with a more limited range of character sets. This section highlights ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-borland.html
With all Borland applications where the Borland Database Engine (BDE) is used, follow these steps to improve compatibility: Update to BDE 3.2 or newer.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualobjects.html
Select the Don't optimize column widths option. ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-performance.html
The Connector/ODBC driver has been optimized to provide very fast performance. If you experience problems with the performance of Connector/ODBC, or notice a large amount of disk activity for simple queries, there are a number of aspects to check: ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-executemany.html
An optimization is applied for inserts: The data values given by the parameter sequences are batched using multiple-row syntax. Syntax: cursor.executemany(operation, seq_of_params) This method prepares a database operation (query or command) and ...
https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html
You can turn automatic conversion on for convenience, or off for optimal performance. MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). For notes detailing the changes in each release of Connector/Python, see MySQL Connector/Python Release ...
https://dev.mysql.com/doc/internals/en/bulk-insert.html
Instead of writing each key value to B-tree (that is, to the key cache, although the bulk insert code doesn't know about the key cache), we store keys in a balanced binary (red-black) tree, in memory. When this tree reaches its memory limit, we ...