I am designing a system which will have data imported 20-30 times per hr. Would it be better to leave the recordset open and live with the memory that it takes up, or open and close it each time data comes in?
Rohn
Tue, 26 Oct 1999 03:00:00 GMT
Client Excele #2 / 2
Leave recordset open, or close and reopen.
Leave it open, the overhead isn't that bad. PS:> I would use a table object for dynamic changes, its always up to date.
Quote:
>I am designing a system which will have data imported 20-30 times per hr. >Would it be better to leave the recordset open and live with the memory >that it takes up, or open and close it each time data comes in?
Leave recordset open, or close and reopen.