[EMAIL PROTECTED] > I have a program that reads records from a binary file and loads them > into an MS-SQL Server database. It is using a stored proc, passing the > parameters.
[snip] > So my questions is .... > Is there a "faster" method I can use to connect to the SQL server ? > Or does anyone have any "optimization" tips the can offer ? Is there a reason why you need to use a stored procedure? Do you need to process the data in some way in order to maintain referential integrity of the database? If the answer to both these questions is "no", then you can use the "bcp" (Bulk CoPy) utility to transfer data into SQLServer *very* quickly. http://msdn.microsoft.com/library/en-us/coprompt/cp_bcp_61et.asp http://www.sql-server-performance.com/bcp.asp thought-it-was-worth-mentioning-ly y'rs, -- alan kennedy ------------------------------------------------------ email alan: http://xhaus.com/contact/alan -- http://mail.python.org/mailman/listinfo/python-list