sql - Coldfusion getting data from a second datasource -

sql - Coldfusion getting data from a second datasource -

i have query gets info sec datasource. slow. there more effective way this?

i think part slow listqualify. results in list contains 40,000 values. i'm not sure of way it.

<cfif getextractiondata.recordcount gt 0 > <cfquery name="queryvpocar" datasource="web_applications"> select [strstocknumber] "stock", field1 "field_1", field2 "field_2", field3 "field_3", field4 "field_4", field5 "field_5", field6 "field_6" extractionaggregates [strstocknumber] in (#listqualify(stocklist,"'",",","all")# ) </cfquery> <!--- select empty row ---> <cfquery name="joinquery" dbtype="query" > select * queryvpocar queryvpocar.stock = '' </cfquery> <!--- add together empty row table, have column names ---> <cfset queryaddrow(joinquery) /> <!--- if results exist, add together them query ---> <cfif queryvpocar.recordcount gt 1 > <cfquery name="getextractiondata" dbtype="query"> select * getextractiondata, queryvpocar getextractiondata.stock = queryvpocar.stock union select getextractiondata.*, joinquery.* getextractiondata, joinquery getextractiondata.stock not in (#listqualify(valuelist(queryvpocar.stock),"'",",","all")# ) order stock </cfquery> </cfif> </cfif>

a improve way utilize sql server much of database work possible. step 1 install linked server oracle db on sql server. step 2 write stored procedure that:

uses openquery info oracle , puts info temp table of sql server database. gets info sql server database tables joining temp table

step 3 phone call stored procedure coldfusion , display results.

sql sql-server coldfusion