ubuntu-touch-coreapps team mailing list archive

[Joey Chan <qqworini@xxxxxxxxx>]

Hi Geeks,

I'm a developer of RSS reader, I found a performance issue in qml database,
which blocks the main thread for seconds.

*issue description:*
<code>
dbResult = tx.executeSql('INSERT INTO article (title, link, description,
pubdate, guid, feed_id) VALUES(?, ?, ?, ?, ?, ?)',
                                 [title , link, description, pubdate, guid,
feed_id])
</code>
I use this code to insert a row of data into database, if just one row
needed, ok with that; but if I need many rows of data to be insert, the
database engine will execute this code many times and blocks the main
thread for seconds.

*solution: *
1. WorkScript.  not support .import includes QtQuick.LocalStorage 2.0   >_<
2. binding or batch execute.  In Qt C++, a list can be binded to a
QSqlQuery, then only execute once to insert them into database, can anyone
teach how to do that in qml?
3. U1DB. I haven't tried it, is it stable now?


Thanks,
Joey