Yup, I learned this week just how well Drupal can fly. Well, maybe not measured in feet above the earth but certainly in terms of response time. Come take a look at a new setup were are testing out.
Popularity: 7% [?]
Drupal can Fly….on a Linode
On August - 27 - 2009
SSWUG vConf – Incremental Data Warehouse Loads with MERGE and Change Data Capture
On April - 24 - 2009
Presenter: Matt Masson
http://blogs.msdn.com/mattm/
This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. Well cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you’re interested in learning best practices for this new SQL Server 2008 functionality, you won’t want to miss this session! Read the rest of this entry »
Popularity: 14% [?]
SSWUG vConf – SQL 103 – DMV’s and T-SQL for the DBA
On April - 22 - 2009
Presenter: Jeremy Lull
Jeremy@datarealized.com
DMV – Dynamic Management Views (and functions)
- Returns server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.* MSFT – 2008 BOL Read the rest of this entry »
Popularity: 4% [?]
MediaTemple Grid Server, Drupal and the Zend Optimizer
On November - 19 - 2008
Today was a great day. First off, the good Lord gave me another day on Earth to do His work. That’s a good start. I also came across a KB article from MediaTemple that provide great hope of some performance improvement on our grid service (gs) account. Now I came across this as a result of researching performance optmizations for Drupal on their dedicated virtuals (dv) that some of my clients sites run on.
I was so excited, I couldn’t wait to try it out. So, nothing too empirical other than firebug net download times with my browser cache cleaned out.
Test Instance with 8 blocks making up a single node page with 100 generated users.
* Before the optimizer was enabled: avg. 4.4 secs total
* After the optimizer was enabled: avg. 2.9 secs total
The change boils down to this:
Open your php.ini file for editing (KB: (gs) HOWTO: edit php.ini). Add these lines:
For PHP4 (Replace the x.x-x with the version number you want to use.)
> zend_optimizer.optimization_level=15
> zend_extension=”/usr/local/php-4.x.x-x/zend/ZendOptimizer.so”
For PHP5 (Replace the x.x-x with the version number you want to use.)
> zend_optimizer.optimization_level=15
> zend_extension=”/usr/local/php-5.x.x-x/zend/ZendOptimizer.so”
Save the changes and quit.
That’s a decent improvement with all things considered. There are plenty of other optimization items that can be done, but since this site provide zero income, I’m not ready to pay any more for some of those non-free options. 
I guess that leaves me with Drupal caching support, ZendOptimizer and MySQL Table optimization and indexing. No MySQL containers for me. If I ever move, it will probably be straight to a (dv).
Blessings!
Popularity: 13% [?]
