The effective lifetime of ultra-cold atoms in specific quantum states plays a crucial role in studying interaction parameters within quantum systems. Measuring the effective lifetime of various quantum states within ultra-cold atoms is a fundamental task in quantum operations. In this paper, the effective lifetimes of the excited electronic states (Formula presented.), (Formula presented.), and (Formula presented.) for a sodium atomic Bose–Einstein condensate (BEC) are investigated in both the optical dipole trap (ODT) and one-dimensional optical lattice. Through the analysis of experimental data, we demonstrate the significant advantage of lattice loading over the optical dipole trap in terms of atomic lifetimes. The results provide crucial insights into the temporal scales relevant for investigating the evolution of boson gases in optical lattices, facilitating the realization of quantum simulations pertaining to unique quantum phases, and providing an important experimental basis for the research of non-equilibrium dynamics between different spin states