On Jan 16, 2007, at 10:10 PM, Navdeep Bains wrote:
Hello,
Just did some testing, and this is what I've observed:
When using the old SQLite plugin, issuing a "BEGIN TRANSACTION"
query results in a "journal" file being created, but the file does
not grow in size as records are inserted.
With REALSQLDatabase, a "journal" file is created automatically and
grows in size as records are inserted. Adding a "BEGIN TRANSACTION"
doesn't appear to have any affect on speed or behavior. A "journal"
file is still created and still grows in size as records are inserted.
Tim, I have no idea why you're seeing a difference. Do you have
AutoCommit set to true? Anyone else care to chime in?
I added exactly one line to my existing code:
App.CatalogDB.SQLSelect("begin transaction")
With that line inserted, things speed up dramatically. By removing
it, the import crawls. However. I get the transaction log in either
case.
Tim
--
Tim Jones
[EMAIL PROTECTED]
_______________________________________________
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>
