Click to See Complete Forum and Search --> : too much time ti integrated a big sql file with isql online command


sebasttien
02-14-2001, 04:55 AM
hi,

i try to insert element in two table with one relationship, the first table
is a table of flights the second is a table os stopovers. There 56000 flights
with one or two stopovers by flights. The file contains about 120000 line
of insert instruction like :
insert into vol(...) values(...)
go
insert into escale(...) values(...)
go
...

i do the isql command line to integrate this file :
isql /U login /d database /i filePath /o filelog /P password

the integration time is about 6 hours !!!

is it normal ? where is my error if not ? how can integrate data in SQL7
more quickly ?

thanks

regards