I have written an client application that runs on mysql that downloads its data through a web service from ms sql 2000. My web service passes the data in a dataset.
The problem i am having is speed. deleting the old data out of mysql and inserting the new(rewrites the old data with the updated data not all data in the tables are updated). thousends of records are sent down to the client application. I have tried using normal datasets. Much to slow. I have tried generating the deletes and insert statments. which is a lot faster . but still to slow. How can improve peformance in the deletetion and insertion.
So basicly i am loopimg through the rows and columns and generating the delete and insert statement. the looping is quick. its the sql statement that takes a long time to execute. The tables are indexed.
The problem i am having is speed. deleting the old data out of mysql and inserting the new(rewrites the old data with the updated data not all data in the tables are updated). thousends of records are sent down to the client application. I have tried using normal datasets. Much to slow. I have tried generating the deletes and insert statments. which is a lot faster . but still to slow. How can improve peformance in the deletetion and insertion.
So basicly i am loopimg through the rows and columns and generating the delete and insert statement. the looping is quick. its the sql statement that takes a long time to execute. The tables are indexed.