Post reply

Linked Server to Informix database

  • December 3, 2008 at 9:46 pm

    #202464

    In the process of connecting to an Informix database via Linked Server. We are looking at developing views and stored procedures within Informix which will be queried periodically by SQL Server. Is there a performance hit if the views and stored procedures are developed within the SQL environment but make calls via Linked Server to tables within the informix database?

  • December 5, 2008 at 9:15 am

    #908407

    Of course, it depends. Remember that if SQL Server does any calculating, casting, joining, etc, you might force the linked server to pull the whole table locally, and then perform the operations. Whenever possible, you should do work at the location of the data. The driver you connect through will try to translate the requested operation to be done on the linked server, and can in many cases.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply