Bodybag Posted February 10, 2005 Posted February 10, 2005 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. Quote Programmers are trying to create bigger and beter idiot proof programs.The universe is trying to create bigger and beter idiots and so far the universe is winning.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.