This sounds very expensive process in terms of cpu resources... each table you open is kept in memory..... see!!! each table that's not being used
should be closed and set to nothing...
regards
"Sergi" wrote:
> HI people,
>
> I have a VB application with DAO and i am migrating it to ADO. In this
> application, first of all, I connect to database and I open a ado recordset
> for each table in database.
> If i need some information of table, i use this recordset. It is a good
> practice???
>
> Is better open a recordset with table only when I need it???
>
>
>
.
Re: recordset.save takes too long! ...database and converts the data to another Access ... I've got over 29,000 clients to convert and its taking forever. ... I am looping thru the SQL recordset, doing an .AddNew on my Access ... There is a save method on an ADO Recordset that is used to persist the data to disk in either an ADTG or XML file. ... (microsoft.public.vb.general.discussion)
Re: Recordset question in ASP .NET ... this is not something that you "need" a database or recordset for. ... You could simply read the data in from the text file (names and passwords) ... >> the ADO Recordset, it uses a new group of objects for storing ... (microsoft.public.dotnet.framework.adonet)
Re: One recordset for every table. Is it good practice?? ... I execute a select / Stored procedure directly on the table ... For me, there is no reason to create a recordset if you don't need it, ... > application, first of all, I connect to database and I open a ado recordset... (microsoft.public.vb.database.ado)
Recordsets as Query Sources? ... I have a database with a number of M2M relationships, which I have gathered together in a very long query... which I use to build an ADO recordset for one "record". ... Is there any way I can run queries on that recordset?... (microsoft.public.access.queries)
Re: Connection types and speeds ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ... (microsoft.public.access.queries)
