ASP updating dB with 200+ records

[NikkP]

Hi, I am trying to update a table from an ASP page using ADO, the dB is an Access 2000 dB.

I am just wondering what the best way update the table with regards to performace, currently I am just using the simple INSERT statement in a loop. I have been told that this may cause the server to crash as there may be the possibility if being 200 records!

Can anyone tell me the best way to go about such a procedure, disconnected record sets???

thanks

 

[MaeJams]

Are you talking about 200 records a day? If so, you may want to consider using a different database tool. Access is good for rapid app development and small databases, but once you start using it as a heavy back end data storage tool, you run into issues. I would suggest using a SQL Server backend (even Oracle would be better than Access).

If this is not an option for you, I don't see a better way than the way you are doing it. 200 records is really not a lot, so you may not even crash the server as you were told. But if it is 200 a day, you will eventually bog Access down.

I hope this helps.
Rich