Loading direct from Delphi - or any app - may take a while if it's large/wide. Have you tried using BCP? It's the fastest method for doing text file transfers. If the file need manipulation first then you could use Delphi to create a formatted file or load it into a temporary file and use an SP. ----- Original Message ----- From: Renato Haber <[EMAIL PROTECTED]> To: Multiple recipients of list database <[EMAIL PROTECTED]> Sent: Friday, August 27, 1999 12:06 AM Subject: [DUG-DB]: Migratimg data from TXT to SQL Server 6.5 > 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
