When you’re applying for a job, especially if it is in the IT sector, it’s getting quite common for an employer to look for you on any search engine these days. But shouldn’t we start Googling our (blind?) dates? Who knows, he might just be that old dirty guy from around the corner!
After plowing through tons of code from both vTiger and ADOdb and pushing Google search to the max, I finally found a forum topic on vtiger.com covering the problem we were having with vTiger. The problem was that the popup to select an account or a product had load times averaging 60seconds. That’s a huge usability issue (read: waste of time) when you are creating invoices or filling out your calendar.
Anyway, all the more reason to place it on my blog, with the all right keywords!
And now, for the solution:
Quoting onwealdandy
However, I fixed the performance issue with a work around that doesn’t make much sense, but worked. I read this forum post a few days ago, but couldn’t see how commenting out debug print lines would speed things up. But, that did the trick. However, I did narrow it down to the exact variable causing the ruckus ($list_result) , so I only had to comment out just a few lines in ListViewUtils.php. (any debug log lines with $list_result)Even with logging set to FATAL, the slowness would occur. When you did set logging to DEBUG, one instance would show the correct information in the debug log for the debug log lines .. basically what you would expect when printing $list_result (which is a recordset object) .. the object id … “Object id #40″ … however on the slow machine it would actually print the 2000+ records which were returned by the query.
There must be a bug in php or apache or mysql ( no idea) that returns the entire result set to $list_result when its evaluated for printing. My guess is that the libmysql.dll must have a default _tostring method in there in some versions. BE CAREFUL .. since there its not documented which versions do this … for the record, my troubled instance was running php5.2.5, apache 2.2.6, and mysql 5.0.45
You can find the original vTiger topic here: http://forums.vtiger.com/viewtopic.php?p=64335
Posted in rant
If you are a real developer, there should be a huge smile appearing on your face. Thanks to coding horror! Get the bumper sticker version of it while they’re hot!
After working for a Search Engine Advertising company for about 2.5 years, I’ve finally taken the Google Adwords exam and am now a Google Adwords Qualified Professional! My thanks go out to Wim, Fiorella & Annelies for their assistance!
Posted in rant
The launch of the new website of “De Kreuners” was announced 2 weeks in advance on almost every radio station, in many magazines and even on national television. Since I’m a huge fan of them (read: they’re alright), I had to endure 2 weeks of sleepless nights, constantly pondering how awesome the new website would be!
As of today, the new website of “De Kreuners” has been made available. But can we call the new website an improvement? Was it really worth all those nights pressing the f5 button repeatedly, hoping to catch a glimpse of it? Read on!
