MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: preparedStatement.setTimestamp is About ten times slower than others
Posted by: Filipe Silva
Date: October 31, 2019 09:43AM

Yes, setting Timestamp is an heavy operation ATM. We are working on making it better but we have do find a better solution for addressing the lack of support for Time Zones in temporal data in MySQL. Right now, whatever we do on this regard would be a hacky solution and we need to be very careful about it so that we don't regret later.

If you are sure about the exact format and don't care about Time Zone alignments you could try sending these temporal values as strings.

IHTH

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
preparedStatement.setTimestamp is About ten times slower than others
gg chang
October 31, 2019 02:45AM
Re: preparedStatement.setTimestamp is About ten times slower than others
Filipe Silva
October 31, 2019 09:43AM


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.