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.
I am using pywin32 to create a connection object. Once the connection is open I simple pass the SQL formatted commands using cnx.Execute(sqlstring). My test examples; 20,000 records using the ADO connection: 0:04:45:45 If I setup the program to not send the record to the database - so all other variables and processes are constant, it simply just skips the cnx.Execute(sqlstring) step, then it takes only 0:00:25:78 to process thru the same number of trx. Obviously the times in my test are that , but I have a client that woud like to use this and has several million transactions to content with. 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 ? -- http://mail.python.org/mailman/listinfo/python-list
