Alan Kennedy wrote: > [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. > >> 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, > If the answer to some of the earlier questions is "yes," I have found "bcp" can be a great tool to fill up a new table of data "on its way in." SQL can then move it to where it should really go with nice transaction-protected SQL, proper index-building and so on. After distributing the data, you can drop the table of pending data.
I agree this is off-topic, but it is too close to my experience. --Scott David Daniels [EMAIL PROTECTED] -- http://mail.python.org/mailman/listinfo/python-list
