hi,

i will not be inserting a million rows daily. it has approximately a million rows. let's say i have a front end from which users enter 1000 transactions a day. if different users are using diferent connections, will tbe bind variables give me the same performance ? in my application, the same user does not repeat the query. there may be connections inserting into the same table. will bind variables it still work ? can u give me some disadvantages(like memory usage ?) of stored procs if any ?

satish