How to keep tables updated that are imported from other database

[imranabdulaziz]

Dear All,

I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End.

Actually I am fetching data from other database(named as retailexcel but in same server). I have wriiten a view (in retailexcel database) to get required data from four table of other database. My problem is when I fetch those data(about 40000 to 50000 record) It taking to much time. I tried catch feature of asp.net2.0. Time reduced but not significantly. So I am trying to import those tables to my database (named Inventory) from that retailexcel.

Now problem is every day or two, record of those tables changes. How can I keep update my tables (which are importing from retailexcel)
Please suggest me some idea.

Thanks

[iburyak]

I don't think it is going to be much faster.
Did you try to run the same from that database?

Do following tests:

1. Go to original database and run a view from their.
2. Go to your database and run the view.
3. Run the same from the application connecting to original database.
4. Run the same from the application connecting to your database.

Time everything.
A. If test 1 much faster then test 2 you need to bring data to the same server as you originally planed.
B. If first two tests have the same run time it means it will not help to bring data to the same database.
C. If test 3 and 4 run much slower then back end run it means network is having a problem passing large data.
D. If test 1 and 2 are the same but very slow. Take a look at your view and optimize it.

Hope it helps.