SELECT p.pid, p.filename, AVG(v.vote) as avgv, COUNT(v.vote) as avgc FROM wp_ngg_pictures p LEFT JOIN wp_nggv_votes v ON (p.pid = v.pid) ...
PHP SQL Query Optimization
by https://www.google.com/accounts/o8/id?id=AItOawmyRuor7Z0aC0QytK3lMrz5h5jH73-dECw,
December 13, 2011 21:03,
3 refactorings, tagged with speed, sql, optimization
This SQL query is currently...
function demortonize($n)
{
$row = $col = 0;
...
PHP De-interleaving bits. Again
by acmesquares.myopenid.com,
January 21, 2011 16:36,
1 refactoring, tagged with speed, php, interleave, bitwise
Function needs to take a se...
$css = preg_replace('/\s\s+/', '', preg_replace('@/\\*([\\s\\S]*?)\\*/@','',$css));
PHP Remove Whitespace & Com...
by https://www.google.com/accounts/o8/id?id=AItOawlfLKQUOxClQ5HmGAqM_lnwQLGwjnkD4TI,
January 06, 2011 20:34,
4 refactorings, tagged with speed, php, regex
I'm wondering if this is th...
<?php
//class
class Collection{
...
PHP How should I optimize this ...
Hi everybody!
I'm kinda ne...
<?php
function word_limiter( $text, $limit = 30, $chars = '0123456789' ) {
if( strlen( $text ) > $limit ) {
...
PHP Limit amount of words displ...
It returns a string with a ...
This script simply retrieve...