|
|
Posted by weetat on 02/05/07 06:58
Hi Eric ,
In PHP , I believe that there no such tools for example , connection
pooling .
The connection pooling is use to manage database resources in the
database related web page. In Java , there are many connection pooling
and In Tomcat Servlet container have it too.
However , php lacking the connection pooling.
I am not very sure in PHP , when you have call close connection
method , it will delete the connection at all.
If not , it will cause your web page to be very slow.
In my php project ,I have this problems however , i cannot find any
ways to solve it.
Maybe someone who expertise in PHP can help you .
On Feb 6, 5:11 am, "Eric Layman" <erricson@lays> wrote:
> Hi,
>
> Many years ago when I first learnt abt web dev in school,
>
> I was taught this methodology:
>
> [Open connection]
>
> <html>
> blah blabh
>
> [execute sql]
> [loop thru recordset]
>
> <table>[data] </table>
>
> [recordset close]
> [end loop]
>
> <html>
>
> [Close connection]
>
> Over the peroid of time, I noticed that the above method may cause
> connection problems on heavy sites.
>
> Recently, I have use another method to retrieve data from server
>
> [Open Connection]
> [declare 2D array]
> [loop thru recordset]
> [2D array] = [data]
> [recordset.close]
> [end loop]
> [Close connection]
>
> <html>
>
> [loop thru the 2D array]
> <table>[2d array's DATA] </table>
> [end array loop]
>
> </html>
>
> It performs better as all the data retrieveal and processing are all
> processed at the beginning of the page.
>
> Need comments and advise please.
>
> 1. Are there better ways to manage connections and easier data retrieval to
> ensure performance of the site under heavy load?
>
> 2. Are there any potential pitfalls regarding my 2nd method of data
> retrieval?
>
> Thanks
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com
[Back to original message]
|