JSqlParser is slow on the very first parsingThe very first statement takes a lot to be parsed. I think this depends on the static methods and classes generated by JavaCC. I will try to figure out if this is a problem relating JSqlParser or JavaCC.
Numbers in queries
Suppose you have a query like:
SELECT * FROM MY_TABLE WHERE ID=4
JSqlParser will represent the "4" with a LongValue, while an integer would have been enough. The same applies for decimal numbers:
SELECT * FROM MY_TABLE WHERE ID=4.3
JSqlParser will represent the "4.3" with a DoubleValue, while an float would have been enough.
The reason is simple: JSqlParser can't know which datatype your columns/variables are. Anyway, you should always use Jdbc placeholders in your code:
SELECT * FROM MY_TABLE WHERE ID=?
this way there are no problems.