Can anyone please enlightem as to what are the implications are of not including the mysql_free_result() function at the end of a dynamically generated page that uses PHP and MYSQL.
Subscribe to HRA Now!
Are you a Google Analytics enthusiast?
Share and download Custom Google Analytics Reports, dashboards and advanced segments--for FREE!
www.CustomReportSharing.com
From the folks who brought you High Rankings!
More SEO Content
International SEM | Social Media | Search Friendly Design | SEO | Paid Search / PPC | Seminars | Forum Threads | Q&A | Copywriting | Keyword Research | Web Analytics / Conversions | Blogging | Dynamic Sites | Linking | SEO Services | Site Architecture | Search Engine Spam | Wrap-ups | Business Issues | HRA Questions | Online Courses
Sponsored Content
Mysql_free_result() Function
Started by
piskie
, Dec 18 2011 05:27 AM
2 replies to this topic
#2
chrishirst
-
- Moderator
-
- 5,881 posts
A not so moderate moderator.
- Location:Blackpool UK
Posted 18 December 2011 - 09:34 AM
Nothing in particular, but it will free the memory resources that are being used by the query results and if your MySQL server and webserver are on the same hardware it means that the shared memory space is freeded up sooner and available to other processes.
If your queries are relatively inefficient, and/or the queries are returning large result sets it can make the application and server a little more responsive as the resources are released before the session ends.
If your queries are relatively inefficient, and/or the queries are returning large result sets it can make the application and server a little more responsive as the resources are released before the session ends.
#3
piskie
-
- Active Members
-
- 1,092 posts
HR 7
- Location:Cornwall
Posted 19 December 2011 - 04:36 PM
Thanks Chris
That was a good guess of yours, my queries are almost always more evolutionary than structured and optimised. So I now know to go round and put the free_result in the pages where it's missing.
That was a good guess of yours, my queries are almost always more evolutionary than structured and optimised. So I now know to go round and put the free_result in the pages where it's missing.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
