I've added the BEGIN TRANSACTION but it hasn't really made a change
to the speed.
I'm using a New DatabaseRecord to add each row from the in-memory db
- would INSERT INTO be quicker? Or are there any other tricks to
saving an in-memory db to a file? I really need to speed this up
dramatically, any ideas would be great thanks.
This is close to my code but there are about 20 columns in my live code.
rs = memdb.SQLSelect("SELECT * from trax")
db.SQLExecute("BEGIN TRANSACTION")
While Not rs.eof
sdr= New DatabaseRecord
sdr.Column("id") =rs.Field("id").StringValue
sdr.Column("Name") =rs.Field("Name").StringValue
sdr.Column("Album") =rs.Field("Album").StringValue
sdr.Column("Composer") =rs.Field("Composer").StringValue
f=getfolderitem(rs.Field("Location").StringValue)
sdr.Column("Location") =f.name
db.InsertRecord("trax",sdr)
rs.MoveNext
Wend
db.Commit
Thanks
Jeff
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
