Can the transaction log be turned off?
-
Hi,
Can anyone tell if it is possible to turn off the transaction log file so I can write directly to the table?
It is a performance issue and I need to write to to table as fast as possible
Regards
Martin
-
No, SQL Server does not work that way. What are you trying to do exactly, perhaps there is a good solution for handling it.
-
Hi Chris,
I have a VB program that attches to a table in SQl server.
I loop through this table getting an X-Y coordinate.
I find the nearest map object to this coordinate and then update the row with the ID (Integer) of that map object.
I have 13 million rows to process. the allocation seems to run OK but when I issue a commit it take forever to save.
Any ideas would be good.
Regards
Martin
-
Have your application do this in batches. Read a number of rows into a disconnected recordset, process the numbers and write the results to a file. When you are done, use DTS or BCP to bulk insert this data into the database and update the existing data. Or something similar..
-
Thanks for the advice.
I will give it a go
Regards
martin
-
You can also set the recovery mode of that database to simple, which will mean not every single thing gets logged in the transaction log.
Just make sure you back up this database regularly if you do this.
Hope this helps.
-
Hi
Thanks for your help with this.
I have decided to writ ethe result to a file. it is not much quicker for processing but the saving is a big difference
Thanks again
Regards
martin
-
No probs
-
Simple recovery mode does not mean things are not logged. It only means that the log can be truncated after a checkpoint. If an application is inserting a huge number of rows in a single transaction it will not do any difference to have a database in simple recovery mode.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply