hi,

suppose if i have a transaction table with 1 million rows. If i call an insert stament from VB, the statment will be parsed each time because the values will defer. but if i write a stored procedure to do the inserts, i pass all the values to the proc which already has a pre-compiled insert statement and uses bind variables to insert into teh database. wouldn't it be better in terms of performance. or will calling the stored proc have a big overhead ? what will be the performance gain ?

satish