Create a new table to do this and add a trigger on op to make the sum. ----- Mensagem original ----- De: "Stéphane MANKOWSKI" <steph...@mankowski.fr> Para: sqlite-users@sqlite.org Enviadas: Terça-feira, 1 de Junho de 2010 16:57:16 Assunto: [sqlite] Performance issue on view
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 -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
