i have created Application which is in Vb 6.0-SQL7.0.
currently there are 5000 records stored in database
now when i am going to insert new record thorugh VB Application it takes near about 2 min.I have used "INSERT" statement which is executed through connection object of ADODB.
so is there any way to minimize the time of exectuion.
thanks in advance