how long we can execute prepared statement after prepared once?

*****As i read out, I think whenever i need to perform any query again and again, ( a big no. of time) , prepared statement is best solution because it save time by not to parsed query again and again,**

I want to know after preapared once, how long i can execute prepared statement,

suppose my window application have 10 different frame( window), so i can execute it from different frame,while declare in another frame开发者_运维技巧, what is the scope of prepared statement?

if for inserting millions of record (automatically) ,if we use stored procedure so how it can spoil the system?

One prepared statement is valid through out one request. Different frames are separate requests, so the statement is not reused among them.

You have to bound values to a prepared object anyway, so this should be obvious.