ramblings on PHP, SQL, the web, politics, ultimate frisbee and what else is on in my life
[1] « 1 2 3 4 5 6 7 » [48]Persistent connections with MSSQL
Hoping someone can explain to me what is going on here. We are connecting to SQL Server via mssql_pconnect(). MaxChilds is set to 256 and we are only establishing one connection per request. So as a result I am expecting a maximum of 256 established connections. A client went into production yesterday and due to a missing index the server ended up being insanely loaded, as the queries started to block each other. The sysadmin checked the state of things via netstat and found that there were close to 500 tcp connections to the SQL Server. What gives?
read on (comments 8)
PHP 5.3.0alpha3 is finally out
Wow, after what feels like ages PHP 5.3.0alpha3 was just released. Originally we hoped to be able to release now intermediate releases every 2-3 weeks, this one took a good 2 months. Somehow this releases did its very best to stall itself. People that needed to work on things together by chance ended up being busy with other things and vacations in just the right order to make things impossible. Most of this was to be attributed to the namespace discussions, which climaxed in the backslash FUD campaign. I think we have finally a workable solution and its even documented! Greg even added a long promised FAQ. I am also happy to see that Christian got his rounding RFC committed.
read on (comments 6)
Short mental note on fulltext indexes
I rarely use MySQL Fulltext indexes. Their performance is just not good enough, so often its better to just stick with "LIKE" or move to something else like Sphinx, Lucene etc. The only nice thing about them is the ability to compute a match "rank". Well anyways I had to write a new search plugin for a project that is based around MySQL Fulltext indexes and a match rank and all as well .. except that for some reasons some words just would not produce any results. As I was trying to find a pattern I finally noticed that in my test data some words were used in most rows and exactly those were not matching. Obviously it makes sense to exclude automatically any words that have a very high hit ratio. And indeed the documentation states that by default all words with a hit ratio of over 50% are excluded. Doh!
read on (comments 3)
48 hours later .. and I still feel good
Two days after having finally settled on a namespace separator, having read all of the big threads on reddit and slashdot, countless blogs, hate mail send to my private email, hate mail to internals, whining on IRC, I still feel good about the choice we made. Very very very few of the critics even understand the problems. Even less are able to formulate their concerns in a manner worth answering. So yup, none of the things people whine and moan about that could have been done instead make me reconsider.
read on (comments 14)
It's official: I am idiot
Thankfully it's just me and not the rest of PHP internals. So today we had an IRC meeting to discuss namespaces in PHP. We came to a final decision replacing the current double colon separator with a backslash to solve ambiguity issues with the current syntax. So far there has not been much of a reaction on list, except for a post which mentioned concerns related to the fact that backslash is currently used for escaping, but which was quickly responded by Greg to point out that yes we were aware of this, but it is not an issue if you know how to use the backslash properly in double quote strings.
read on (comments 12)



