thegraingers Posted January 3, 2006 Share Posted January 3, 2006 sorry about the double posting, my browser errored the first time USE THe OTHER POST Quote Link to comment https://forums.phpfreaks.com/topic/3140-mysql-connectclose/ Share on other sites More sharing options...
fenway Posted January 3, 2006 Share Posted January 3, 2006 I assume you mean [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=82506\" target=\"_blank\"]this topic[/a], but there's no post there!?!? Quote Link to comment https://forums.phpfreaks.com/topic/3140-mysql-connectclose/#findComment-10573 Share on other sites More sharing options...
thegraingers Posted January 3, 2006 Author Share Posted January 3, 2006 [!--quoteo(post=332901:date=Jan 3 2006, 09:42 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 3 2006, 09:42 PM) 332901[/snapback][/div][div class=\'quotemain\'][!--quotec--] I assume you mean [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=82506\" target=\"_blank\"]this topic[/a], but there's no post there!?!? whooooops, so any answers to my question............. Quote Link to comment https://forums.phpfreaks.com/topic/3140-mysql-connectclose/#findComment-10575 Share on other sites More sharing options...
LazyJones Posted January 3, 2006 Share Posted January 3, 2006 Answer: "Yes, those mushrooms were very poisonous" Quote Link to comment https://forums.phpfreaks.com/topic/3140-mysql-connectclose/#findComment-10577 Share on other sites More sharing options...
thegraingers Posted January 3, 2006 Author Share Posted January 3, 2006 my question, which appears to have been lost is Is it better on a web page to open a mysql connection at the start of the page, do a number of queries and then close the database connection OR if it is possible to split the queries up would it be better to do a number of open, query, close operations. a typical page might look like this query for advert selection query to log advert shown query for another advert query to log advert query to populate part of a side menu query for a poll in side menu query for page content query for another advert query to log advert etc Quote Link to comment https://forums.phpfreaks.com/topic/3140-mysql-connectclose/#findComment-10579 Share on other sites More sharing options...
fenway Posted January 4, 2006 Share Posted January 4, 2006 Don't re-connect multiple times... too much overhead. Once per page is always the right way to go. Quote Link to comment https://forums.phpfreaks.com/topic/3140-mysql-connectclose/#findComment-10586 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.