Hi.
I have just started using Pear :: DataObjects and I would like to know how do they manage database connections. If you use several dataobjects in a script, do they use the same database connection or each of them open a new one?. In the log of mysql I can see a lot of lines like this:
mysql\bin\mysql d.exe, Version: 5.0.27-community-log. started with:
Tcp port: 3306 Unix socket: mysql
070418 19:15:54 72 Connect mydatabase@loca lhost on
72 Init DB mydatabase
72 Init DB mydatabase
72 Query SELECT *
FROM `Language`
72 Init DB mydatabase
72 Init DB mydatabase
72 Query SELECT *
FROM Anio
72 Init DB mydatabase
72 Query SELECT *
FROM Anio
72 Init DB mydatabase
72 Query SELECT *
FROM Anio
72 Init DB mydatabase
72 Query SELECT *
FROM Hotel
WHERE ( Hotel.idHotel = 1 )
...
So I think that those dataobjects are not sharing the database connection, which would make the application really slower. Does anyone know a way to verify and configure it?.
Thanks.
I have just started using Pear :: DataObjects and I would like to know how do they manage database connections. If you use several dataobjects in a script, do they use the same database connection or each of them open a new one?. In the log of mysql I can see a lot of lines like this:
mysql\bin\mysql d.exe, Version: 5.0.27-community-log. started with:
Tcp port: 3306 Unix socket: mysql
070418 19:15:54 72 Connect mydatabase@loca lhost on
72 Init DB mydatabase
72 Init DB mydatabase
72 Query SELECT *
FROM `Language`
72 Init DB mydatabase
72 Init DB mydatabase
72 Query SELECT *
FROM Anio
72 Init DB mydatabase
72 Query SELECT *
FROM Anio
72 Init DB mydatabase
72 Query SELECT *
FROM Anio
72 Init DB mydatabase
72 Query SELECT *
FROM Hotel
WHERE ( Hotel.idHotel = 1 )
...
So I think that those dataobjects are not sharing the database connection, which would make the application really slower. Does anyone know a way to verify and configure it?.
Thanks.