SQL Slow access, a lot of timeouts and locks.
Posted on 2006-05-18
Have Win03 and SQL 2000 setup and running. Use a Program Called Macola ES to access the database and also a few ASP pages I have writen. Data is taking a long time to come from the database, and causes the tables to lock and timeout. There is one location that uses the Macola ES program from a wireless USB Network card and that one takes 2x-3x as long as the PCs on the normal LAN to process an item. Any issues, or ideas that we can try to speed up SQL Server or the workstation's link to SQL via Wireless? The other Wireless locations are only accessing an ASP page witch is slow also, and times-out if the other PC locks the table.