gistfile1.txt

test
<cfscript>
cfsetting( requestTimeout="999999");
results = [:];
cfloop( from="1", to="2", index="x", step=2 ){
    rows = (x)^3;
    variables.qry = queryNew("id,name", "integer,varchar" );
    cfloop( from=1, to=rows, index="i", step=4 ){
        qry.addRow([[i,"brad wood#i#"], [i+2,"Rachel wood#i#"], [i+3,"Luis Majano#i#"], [i+4,"Gavin Pickin#i#"]]);
    }
    tries = [];
    cfloop( from="1", to="3", index="asdf" ){
        start = getTickCount();

        result = queryExecute(sql="
            SELECT lower(upper(name)), 24234234*453534543+4535435/2, name, id as id1, id as id2, id as id3, id
            FROM qry
            WHERE
                name like '%wood%'
                and id > 0
                and id/1 < 100000000
                and lower(upper(name)) like '%wood%'
        "
        ,params={}
        ,options={dbtype="query"}
        );
        tries.append( getTickCount()-start )
    }
    results[ rows ] = tries.avg();
}

writedump( results )

</cfscript>