do not use transaction on import and do a "vacuum full" before calculating the rank