November 7, 2012 at 7:48 pm
Insert 100000 records need to take 8 mins in sql 2012 if compare to sql 2008 just take 1 mins. Any ideal why like that?
November 7, 2012 at 7:52 pm
You'll need to supply a lot more information than this.
Are there server differences, disk differences, have you compared execution plans,....
Have you rebuilt indexes, updated stats?
There are a host of things that can affect performance, so it's impossible to say from your short comment what it could be.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
November 7, 2012 at 8:00 pm
If assume the server, disk , index are all same. Just use different SQL version, SQL 2012 vs SQL 2008, why the SQL 2012 will take longer time to insert the data? very curious now.
November 8, 2012 at 1:02 am
It shouldn't be.
Take a look at the query plans to find out what's wrong.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 8, 2012 at 1:11 am
I get a solution from this article, seems faster abit, but not very useful.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply