I am using SQLObject with an sqlite database to store document records. The documents have been scanned the document information stored in a text file. I need to read all these text files (about 800) and load document records from them (average 40 documents per file).
Currently my code is as follows (Document is the table) :-

Presumably SQLObject is committing the record each time I change the attribute, which is wasteful. If I were just adding records I could create the attributes at the same time as the record is first created and this should be faster, but still SQLObjects seems slow at adding records.