[sqlite] VACUUM'ing

ACUUM command after remove rows from session table. Which solution is better and faster in this case ? Regards, Bambero -- Bambero <[EMAIL PROTECTED]> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/list

[sqlite] Changing order

, test1, test1, 1 2, test2, test2, 2 3, test3, test3, 3 Now i want to "move down" row with id 2, to table looks like this: 1, test1, test1, 1 2, test2, test2, 3 3, test3, test3, 2 Any suggestions ? Maybe there is better way to moving rows ? Regard