For the record, this is unrelated to the other project I have been working on.
I have a database that is used just for the purpose of warehousing data. It has a couple supporting tables, but the main table (tblTicketDetails) holds all of our sales data so I can easily access it for reports and such. I have created a second database that has that table as a linked table and so far every query I have designed to run against it is quite slow (can take over a minute). The table in question does have over 2 million records but I feel like that shouldn't cause performance problems quite yet, but could be wrong.
I think it may be due to being a linked table as the same exact queries finish in only a few seconds within the database that the table is located in. Is there anyway to increase performance for this?
I have a database that is used just for the purpose of warehousing data. It has a couple supporting tables, but the main table (tblTicketDetails) holds all of our sales data so I can easily access it for reports and such. I have created a second database that has that table as a linked table and so far every query I have designed to run against it is quite slow (can take over a minute). The table in question does have over 2 million records but I feel like that shouldn't cause performance problems quite yet, but could be wrong.
I think it may be due to being a linked table as the same exact queries finish in only a few seconds within the database that the table is located in. Is there anyway to increase performance for this?