Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
madhulatha_b
Starting Member
22 Posts |
 Posted - 2006-10-25 : 12:14:15
|
| I am facing problem while retrieving the data from database.I am trying to retrieve data from one database which resides in one server(Say X) and storing that data in another database which resides in some other server(Say Y)I am trying to retrieve only 30 records, it is taking more than 2 min which is too slow. Normally when we try to retrieve data we could get the data in few sec. But few times(very rare) we are facing this problem. These 30 records we are retrieving from 6 different tables.These two are remote servers.My question here is what could be the reason for this delay in retrieving the records.Is it only because of network? or is this because of using 2 different servers? How can I debug this problem?Please treat this an urgent issue.Thanks in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-25 : 14:22:56
|
| You say nothing about the method to transfer to 30 records.Peter LarssonHelsingborg, Sweden |
 |
|
|
madhulatha_b
Starting Member
22 Posts |
Posted - 2006-10-25 : 23:27:17
|
| Here is the steps to copy data from source server to destination server1.In Source server we retrieve the data from original tables and store that data in temporary tables. 2. Copying data from temporary tables which are in source server to temporary tables which are in destination server will taken care by the component which is developed in delphi. 3. After this again we will copy the data from temporary tables to original tables of destination server |
|
|
|
|
|
|
Problem while retrieving the data from DB