The number of data released by optical-infrared astronomical data archive systems has increased significantly in recent years with the advent of high-speed imaging instruments. In this paper, we investigate the effect of a huge number of data on the search speed and the database/table configuration to speed up searches in the optical-infrared astronomical observation data archive system. We conducted experiments on each search feature (pinpoint search, rough search, and calendar search) of the SMOKA/Tomo-e Gozen system, a data archive system for the Tomo-e Gozen high-speed camera.We report the results of these experiments and discuss the optimal database/table configurations for the optical-infrared astronomical data archive system with a huge number of data.