-
peformance tunning
Hi,
One of our developer is running a procedure ( which does a select and updates and inserts based on certain criteria). The insert is happening for every 10,000 records.Total records inserted will be 100000 in production which is taking 6 hrs.
the same procedure takes 3 hrs in development. This development environment is refreshed with the copy of production with the daily hotbackup.
In development it runs faster when compared to prod?? any ideas.
Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|