• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

SQL delay

I have a major development on several sites which was developed in VB6 using a SQL database.  As you would assume there are several occasions where data is writen to tables.  The application has been on site for many years and has been working under MS SQL exclusively beginning with 2000, and progressing through to 2008.  In the last few weeks the application has been operating on one site under 2012 and I have hit snags.  Some transactions are taking far longer to run with noticable pauses in the application while SQL writes data to tables.

Can anybody provide some general advise on tweating performance before I start sending code snips>
1 Solution
Dave BaldwinFixer of ProblemsCommented:
Have you updated the code to use the newest drivers?
Check you're using the ODBC for SQL 2012. Then try setting the ODBC to log what's going on and look at that for clues..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now