Re: running multiple queries with one connection
Posted by: Chris Bassett
Date: September 18, 2014 11:07AM

OK, I found a solution that "works" but is probably not the best--I had to close the actual database connection, and then re-open it and it seems to be fine, but my concern is resource usage by closing and opening connections repeadedly.

Would this be a problem, because I know each time you open a connection, MySQL increments the connection count(er) by 1, so if you do this a lot, will it have a performance impact after a while on the database server?

Options: ReplyQuote


Subject
Written By
Posted
Re: running multiple queries with one connection
September 18, 2014 11:07AM


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.