I do use a database link on my current project to another server sitting in the same server room. Unfortunately the columns that we need to query on are not indexed on that box and to pull out records takes for ever. If it did not it would be nice to just write the queries to join our tables off theirs. Instead the solution so far has been to run some SPs nightly that copy over the records that we need to query into temp tables in our schema.
-- Aaron Rouse http://www.happyhacker.com/ On Mon, 22 Nov 2004 08:24:58 -0500, Ben Rogers <[EMAIL PROTECTED]> wrote: > > Well, sometimes it's just a heck of a lot easier. For instance, I'm working > on several apps that either deal with data migration or collaborative > creation. The SAP system (running either Oracle or SQL Server) is set up as > a linked server or, sometimes, is just another database on the same server. > Views are then built in the application database that query the SAP system > (read only of course) to build lists of vendors, customers, etc. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184987 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
