Better SQL database performance / memory usage.

Rows accessible incrementally.
Rows.forwardOnly for optimization.

1 files changed, 9 insertions, 3 deletions

diff --git a/examples/declarative/sql/hello.qml b/examples/declarative/sql/hello.qml
index fb6d21c..e43d320 100644
--- a/examples/declarative/sql/hello.qml
+++ b/examples/declarative/sql/hello.qml
@@ -2,10 +2,9 @@ import Qt 4.6
 
 Text {
     Script {
-        function test()
+        function allGreetings()
         {
             var db = openDatabase("QmlExampleDB", "", "The Example QML SQL!", 1000000);
-            print(db)
             var r = ""
 
             db.transaction(function(tx) {
@@ -13,9 +12,16 @@ Text {
                 tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'hello', 'world' ]);
                 tx.executeSql('SELECT * FROM Greeting', [],
                     function(tx, rs) {
+                        /* Inefficient HTML5-compatible way
                         for(var i = 0; i < rs.rows.length; i++) {
                             r += rs.rows[i][0] + ", " + rs.rows[i][1] + "\n"
                         }
+                        */
+                        /* Efficient way: forward only, not "length" query */
+                        rs.rows.forwardOnly = true;
+                        for(var i = 0; rs.rows[i]; i++) {
+                            r += rs.rows[i][0] + ", " + rs.rows[i][1] + "\n"
+                        }
                     },
                     function(tx, error) {
                         print("ERROR:", error.message)
@@ -26,5 +32,5 @@ Text {
             return r
         }
     }
-    text: test()
+    text: allGreetings()
 }