Hi, In the this database file (http://skrooge.org/files/test.wrk), I created a table named "op" containing banking transactions. A transaction has: An unique id An account A date An amount
I created a view named "v_op" with one more computed attribute named "balance". This attribute is the sum of all previous transactions (including current one) for the same account. My problem is that v_op is very slow. This is not usable. What can I do to improve performances ? PS: I don't want to compute "balance" attribute by code and save it in op balance due to the fact that I am using an undo/redo mechanism. Regards, Stephane _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
