----- Forwarded message from Mahesh y <[email protected]> ----- Date: Thu, 26 Aug 2010 17:29:35 +0530 From: Mahesh y <[email protected]> To: [email protected] Subject: DBI Performance for SQL Server
Hi Tim, Hope you are doing good. I am a software programmer struggling to solve the problems in my code. Pls. find below the summary of my problem 1. I am migrating data from MSSQL to MSSQL DB. 2. I am fetching data from source DB, manipulating Data and inserting into Target DB. 3. Data manipulation involves some complex business logic. Note: The SQL statements are prepared. (More than 100 tables are present) a. Data have to be queried from TABLE X, Y and Z respectively and the sequence will change according to business logic. b. One row will be fetched from source and inserted to target at a time. 4. Data model between two DBs are different. 5. I am using Perl, DBI::ODBC to migrate the data. 6. I can only able to transfer 100, 000 records in a period of 60 minutes. The performance is very slow and I am struggling to overcome the problem. Can you pls. ignite some light in my problem ? In case of any queries, pls. revert back. Thank you very much Regards, Mahesh ----- End forwarded message -----
