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