It sounds almost like you're doing one insert per transaction. Try wrapping
multiple inserts into a single transaction and see if that helps. This may
not be appropriate for your application, but it does guarantee that
committed transactions will not be lost.
My apologies if you are already doin
Hi,
I've recently converted a database to use bigint for the indices. Suddenly
simple queries like
select * from new_test_result where parent_id = 2
are doing full table scans instead of using the index. The table has over 4
million rows, of which only 30 or so would be selected by the query.