Fastest SQL access time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need advice on the followin
I have 2 table
table 1 - remote, cant use an S
table 2 - local, can use a S

I do a select on Table1 and it returns the results,

I want to insert all these results into table 2

The problem is that the first table is really slow to access, I have a string of booking Id's i need to pass it and it keeps timing out on a simple select...its the DB! its on rubbish HW and is badly designed but I cant do anything about that so I have to use the most efficent method of getting the data out, or simply copying the required records between the 2 table

whats the most efficent method I should use

thank
Mar
 
Hi mark,

If you have to do it programmatically (what database is?) then you might set
Timeout to a greater value.
There is no other way as to read data and then insert into another base
programmatically .

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

mark said:
need advice on the following
I have 2 tables
table 1 - remote, cant use an SP
table 2 - local, can use a SP

I do a select on Table1 and it returns the results,

I want to insert all these results into table 2


The problem is that the first table is really slow to access, I have a
Click to expand...
string of booking Id's i need to pass it and it keeps timing out on a simple
select...its the DB! its on rubbish HW and is badly designed but I cant do
anything about that so I have to use the most efficent method of getting the
data out, or simply copying the required records between the 2 tables
 
Back
Top