Where are prepared statements stored?
1 posts in topic
Flat View  Flat View

Posted By:   Archana_Dog
Posted On:   Sunday, February 24, 2002 05:40 PM

where are precomplied statements stored in java? My logic says that it should be on server side & have following to press my point :-

I say that if the precomplied stmts lie in the driver, then its of no
use as the database server will again parse the stmt when the query is excuted so
intention of precomplied stmt is lost. But the stmts lying on the server
makes more sense as obvious.. the stmts will not get parsed again & again..
so logically speaking the precomplied stmts lie on server side.

Pls let me know about ur views. Thanx in advance.

Re: Where are prepared statements stored?

Posted By:   Bozidar_Dangubic  
Posted On:   Monday, February 25, 2002 11:04 AM

this depends on the implementation of the driver and the database. each database has its own way of dealing with just about everything so prepared statements are not difference. most likely, you prepared statements are "stored" in the database itself, i.e. once prepared, database stores the execution plan for your prepared query. when that query is presented to the database through JDBC for execution, database already has the execution plan and can skip the optimizer thus helping out the performance. database is the most logical place for prepared statements to be "stored" and driver most likely does not internally store this information on neither client nor server side.
About | Sitemap | Contact