sql - How much more efficient is building a recordset with newquery vs a union & connecting to database? -
How is making query more efficient by using queryNew ()? I recently created a DB call for a "dummy query" across the code, which did not connect to any table like this:
VS
& lt; Cfset IncludeList = queryNew ("code, description", "integer, uppercase") & gt; & Lt; Cfset newrow = queryaddrow (include list, 2) & gt; & Lt; Cfset temp = querysetcell (include the list, "code", 0, 1) & gt; & Lt; Cfset temp = querysetcell (include list, "description", "excluded", 1) & gt; & Lt; Cfset temp = querysetcell (Include list, "code", 1, 2) & gt; & Lt; Cfset temp = querysetcell (include list, "description", "include", 2) & gt; Avoid database connection
For QofQ (i.e. < Code> dbtype = "query" ), while it seems like a good idea, in practice I have seen the server during load crashes when multiple requests are all the same QofQ. Based on stack traces, this Qofq implementation blocks single threads, other threads.
On the other hand, I also do the code querySetCell () object and this is not a display issue
Comments
Post a Comment