or even www.cflive.net
On Thu, Mar 6, 2014 at 5:48 PM, Justin Scott <leviat...@darktech.org> wrote:
>
> > <cfif(serializeJSON(qry1) eq serializeJSON(qry2))>
> > to compare 2 queries
> > or
> > sticking the queries into an array and then
> > <cfif #qryArray1.equals(qryArray2)# IS "YES">
>
> TryCF.com is great for stuff like this. Plug this code into TryCF.com
> and give it a whirl...
>
>
> <cfscript>
> qry1 = queryNew("x,y,z");
> queryAddRow(qry1, 500);
>
> qry2 = queryNew("x,y,z");
> queryAddRow(qry2, 500);
>
>
> timeStart = getTickCount();
> for (i=1; i lte 1000; i++) {
> x = serializeJSON(qry1) eq serializeJSON(qry2);
> }
> timeEnd = getTickCount();
> writeOutput("<p>Serialize Time: " & timeEnd - timeStart & "ms</p>");
>
>
> timeStart = getTickCount();
> for (i=1; i lte 1000; i++) {
> x = qry1.equals(qry2);
> }
> timeEnd = getTickCount();
> writeOutput("<p>Array Time: " & timeEnd - timeStart & "ms</p>");
> </cfscript>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357864
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
