I am new to database, so this may seem like a stupid
I have a large table (about 50Mb) with many records and I
would like to read the records using a SELECT statement with
prefetch, process the records with actionscript, then put
the result back to the SQLite database before fetching the next
How can I do that? Should I use two separate SQLConnection,
one for SELECT and one for UPDATE? Can I run the UPDATE statement
before the SELECT statement completes?