Execute() vs. LRU cache (e.g. fetchval()) vs. Prepared statement

[songololo]

In the case where information is being written to the database, but no information is returned, is there any benefit to using fetch(), fetchrow(), or fetchval() in order to make use of the underlying LRU cache (it appears that no cache is available on execute()?

Similarly, is there any benefit to using a Prepared Statement when no information is being returned? (The PreparedStatement class has no execute method).

Given the above, I'm assuming that the LRU cache and Prepared Statements are only beneficial for when the database has to return information?

[elprans]

Prepared statements are mostly useful for SELECT queries. If you are issuing INSERT ... VALUES, there wouldn't be much difference. That said, DML statements can contain complex subqueries and CTEs, in which case you might find prepared statements beneficial.