Insert into SQL Server slow, slow, slow... 
Author Message
 Insert into SQL Server slow, slow, slow...

Hi,

doing a simple insert into an SQL Server database from Visual Basic
takes a long time (about 1 second for 1 insert).

The ODBC driver is version 2.65.0236

The insert is done as follows:

sql = "insert into table (x,y) values (a,b)"

db.execute sql, dbSQLPassThrough

Anyone knows how to speed things up?

Thanks,

Marc Croymans



Tue, 14 Dec 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Slow, slow, slow search on VB6, ADO and SS7

2. VB4 is slow..slow....slow

3. Slow INSERTs with SQL SERVER

4. SLOW - ADO ASP FOXPRO CDX - SLOW

5. It gets slower and slower.....

6. SQL Server slower than Jet, why???

7. SQL Server slower than Access?

8. vb5/sql server slow

9. SQL Server slow on some workstations

10. Slow VB3.0 and SQL Server?

11. ODBC to SQL Server is Slow

12. SQL Server slower than Access?

 

 
Powered by phpBB® Forum Software