I got one sql server connected to 5 workstations,A small
vb application which updates 10-15 fileds,submission of
each record is taking 35-40secs,we will be updating 50
records at a time span of 30-45 minutes.

Here the time taken to update each record is pain taking.

How can i over come this problem inorder to submit my
records faster.

And ODBC got to do anything at workstation end,i mean we
got to configure ODBC at workstation.

..

The simplest solution is to use SQL Profiler's Index Tuning Wizard to run
your updates and see where you are suffering. You can literally save your
updates to a .sql file and have them run while Profiler tells you what
indexes to create.

Most importantly though, make sure all your tables have primary keys. While
that may slow inserts, updates with WHERE clauses or joins improve markedly
with a well indexed database.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]