Dennis Fogg wrote: > > I used MySQL this time and the db connection times are quick! About 0.02 > - 0.03 sec on my computer compared to 0.57 sec with Postgres. >
Found the performance bug in my ZF infrastructure and wanted to report the real results here (I don't want to incorrectly characterize postgres' performance!). Postgres non-persistent connections now run at about 0.22 sec with some spikes higher (persistent connections were very fast at 0.05 sec but see my earlier links about them). MySQL non-persistent connections run at about 0.08 sec in my infrastructure (slower than my Allen tutorial results and I'm not sure why). These numbers are eyeball numbers, not calculated averages. So, the postgres penalty is about 0.15 sec. I'm very curious if postgres connections to pgbouncer or pgpool are similar (see previous post) but both of these only seem to have linux implementations so I can't try them on my Windows environment. -- View this message in context: http://www.nabble.com/ZF-performance-advice-tf4610974s16154.html#a13186947 Sent from the Zend Framework mailing list archive at Nabble.com.
