We are getting a .sql file with 152K records and when trying to run this file using unix script with below command, is taking almost an hour. is there any way to reduce the time.
SQL FileName : Running_Long.sql
Content : around 152k records like below
go
if exists (select * from table1 where id = 11111) update table2 set id2 = 66666 where id = 55555
go
if exists (select * from table1 where id = 22222) update table2 set id2 = 77777 where id = 44444
go
...
...
go
if exists (select * from table1 where id = 33333) update table2 set id2 = 88888 where id = 99999
go
sql command running from the script: Sybase
isql -Uuser -Ppass -e -n -i Running_Long.sql -o logfile
Thank you
Asked by Venu Vakul
(1 rep)
Feb 6, 2025, 01:27 AM
Last activity: Feb 6, 2025, 08:22 AM
Last activity: Feb 6, 2025, 08:22 AM