MySQL Forums
Forum List  »  Source, Builds, Binaries

Re: Disabling IsComment Check SQLParse
Posted by: Carlin Connell
Date: November 10, 2021 06:17PM

I believe this is actually apart of ODBC as it goes to prepare a statement it tokenizes it.

From what I gather this whole process of parsing can actually be turned off if statements are pre-parsed using the "PREPARE" keyword.

I am trying now to look now for "Bypass ODBC parsing", if that is any different from sending though prepared statements. But, I am struggling to find much documentation.

If anyone would be able to provide a link, or a description of how these two features are the same or different, that would be much appreciated.

E.g. not many results
https://www.google.com/search?q=SQL_INFX_ATTR_SKIP_PARSING&oq=SQL_INFX_ATTR_SKIP_PARSING&aqs=chrome.0.69i59.334j0j9&sourceid=chrome&ie=UTF-8

Bypass ODBC Parsing
https://www.ibm.com/docs/en/informix-servers/14.10?topic=driver-bypass-odbc-parsing

Server Side Prepared Statements (SSPS)
”Teiid provides a standard implementation of java.sql.PreparedStatement. PreparedStatements can be very important in speeding up common statement execution, since they allow the server to skip parsing, resolving, and planning of the statement. See the Java documentation for more information on PreparedStatement usage.” - Exert from:
https://docs.jboss.org/teiid/7.7.0.Final/client-developers-guide/en-US/html_single/

SSPS Documentation
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html#:~:text=MySQL%205.7%20provides%20support%20for,each%20time%20it%20is%20executed.

Options: ReplyQuote


Subject
Views
Written By
Posted
541
October 11, 2021 12:13AM
Re: Disabling IsComment Check SQLParse
270
November 10, 2021 06:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.