SQL Server Slow Response Time

[cms370]

All,

I recently moved from having my database within Access to now having it within SQL. Basically, my access application will remain as the front end and SQL Server will now be the back end.

After getting everything set up I tried to add some data with the access front end. It works fine when the database is contained within access but I have noticed a significant increase in time with the new ODBC connection.

Long story short...After troubleshooting I came up with the idea to just run a simple append query within access (bypassing all of my VBA code within my application) to see how long it would take to add one single value into the SQL Server table (trying to determine if my VBA code is the problem).

After running the simple append query from acces, trying to add just one single record into the table, it takes over 5 minutes to do so.

Does anyone have any idea what could be going on here?? I think I can safely rule out that my VBA code is the culprit and that there is some network issue or ????

Any thoughts would be appreciated. This is my first use of ODBC...

 

[cms370]

Ok...looks like I had an error in my simple append query. That is up and working now.

However, the process still appears to be a bit slow. It took approximately 7 minutes to append 170000 records to the SQL table.

Does this seem correct?

 

[mcclunyboy]

hows your indexing?!