HOWTO: Transactionless UPDATE on a large table 
Author Message
 HOWTO: Transactionless UPDATE on a large table

I have a very large table (2GB and 10m records) and periodically
periodcially perform an UPDATE command which nulls out serveral columns.
This procedure takes what I think is an unreasonable amount of time (3+
hours) to complete and twice that amount of time of it aborts and must
recover. This is only a development server used for testing purposes and
complete recovery is not needed in the event of an abort. Is there a method
to disable transaction logging during this operation?


Fri, 30 Apr 2004 10:32:04 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Update method for large table

2. Inserting large number of records into a large table with SQL/DAO

3. HowTo Copy a Recordset from a Table to an identically structured table

4. help: Howto browse a large recordset?

5. Howto: Large and small exe icon ?

6. HOWTO: Transfer large amount of data online

7. howto create a Textbox larger than 64kbyte ?

8. Using--After Update-- to update field in table.

9. Dataset changes updates grid , How to update SQL table

10. Help: updating text file-Updating Data in a linked table not supported by this ISAM

11. Update a Table from another Table without duplicates

12. update table field from xref table

 

 
Powered by phpBB® Forum Software