Its been a while since I used SQL Server (thank nonspecific deity), but try this: 1) disable indexs 2) disable referential integrity if you can 3) upload the data. BCP is a good tool to use (part of MSSQL) if you can run it from the command line. 4) enable it all again should speed things up again. Nic. " (Renato Haber)" wrote: > > Hi, > > I'm using Delphi 4 Client/Server 4.0 to do a data migration from a TXT file to a >database in SQL Server 6.5. I'm having troubles with the performance. As soon as the >amount of information is growing the performance goes down. > > I believe that I have a wrong setup of the server. So, if anyone have a idea, please >talk to me. > > Thank you. > > []'s > Renato > > ; ----------------------------------- > ; Renato Ribeiro Haber > ; [EMAIL PROTECTED] > ; ----------------------------------- > --------------------------------------------------------------------------- > New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz --------------------------------------------------------------------------- New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
