July 14, 2002 at 9:53 pm
I have run a number of tests in querying a remote ODBC database (Ingres II) through a linked server definition in SQL 2K. When i run a query, either directly against the linked server (server.dbo.table) or using passthrough (OPENQUERY), it takes about 7 minutes to return 23000 rows of a not very large table.
I have tested the same query in DTS and through VB/ADO, and it only takes about 30 secs. I have also tried different combinations of properties on the Linked Server (collation, data access), but can't seem to nail down why it is taking so long.
Anybody seen anything like this before?
July 15, 2002 at 7:10 am
Can yuo tell me a bit more about the remote database. Is it SQL Server? ALso post the details of how you set up the remote connection. And the query you are running.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 15, 2002 at 7:56 am
The database is Ingres II running on SCO Unix. I have set up an ODBC DSN using the CA Ingres ODBC driver, and add the linked Server in SQL as follows:
sp_addlinkedserver 'NAME', '', 'MSDASQL', NULL, NULL, 'DSN=DSNNAME;Database=DBNAME'
I am running a basic 'select * from' on this table, just to test performance, so there are no funky joins going on.
I was just wondering if anybody had come across problems like this with linked servers before. I have pretty much ruled out ODBC and the network as bottlenecks.
Thanks
July 15, 2002 at 8:44 am
I have had not problems with Oracle, DB2, INFORMIX and SQL. I will take a look and see if anything else could be involved and let you know when I can.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply