On 5/16/07, Hongli Lai <[EMAIL PROTECTED]> wrote: > > > On May 16, 5:42 am, Sam Smoot <[EMAIL PROTECTED]> wrote: > > So I guess my question is: Is flushing the statements really necessary > > or are you just working under an assumption the database (Postgres/ > > MySQL) will blindly allow it to grow to unreasonable levels? > > I'm sorry, I do not understand what you mean by "flushing statements" > and "allow it to grow to unreasonable levels".
The former refers to your intention to drop prepared statements after each query. The latter is what would happen if you didn't cleanup these prepared statements - you'd suddenly have hundreds of them in the database. I think databases *would* blindly allow it to grow to unreasonable levels - can they do otherwise? Prepared statements were designed to be made manually; I don't think any of us can predict what happens when you have an insane number of them active, eg. would it be a hog, would it take up memory, etc. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
