Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by glencooley

  1. glencooley

    SQL Server 2008 - Performance Issue

    Thats a good point, we have tried setting the parallelism and it runs faster but not enough. Im just confused that compared to the other DB engines is so poor performing on INSERTS. SQL is our production platform so need to find a way round this, i guess the next step is more hardware.....
  2. glencooley

    SQL Server 2008 - Performance Issue

    Nope, no triggers, no indexes. Its a table freshly created with a varchar(10) and 2 float columns. No blocking issues or waits in activity monitor. Profiler shows each insert statement running in 1.3 seconds which is horrendously slow. We have tried several methods, from individual statements...
  3. glencooley

    SQL Server 2008 - Performance Issue

    No thats the odd thing, no indexes or any constraints. Basically its a 3 column table. We are replicating some of the realtime use the system gets and inserting 1.7mil in batches of one thousand.
  4. glencooley

    SQL Server 2008 - Performance Issue

    Hi Guys Having an interesting problem with SQL Server 2008 at work. We are inserting 1.7million records in to a table (not using BCP but there are reasons for this) and its taking 30-40 minutes to run. When we run the same SQL in PostGres or MySQL it takes a minute or two. Any thoughts on...
See more

Part and Inventory Search

Back
Top