Sphinx's attr_flush_period configuration, if set to a very short time, such as 10, what will happen?

problem description

you want to use sphinx"s UpdateAttributes to do some immediate property update scenarios.
after updating with this method, you need to wait for the time set by attr_flush_period before the index persists to disk before it takes effect.

question: official documents and other people"s projects are set for a long time, such as 900. will there be any performance problems if attr_flush_period is set for a short time, such as 1 second or 10 seconds?

Jun.14,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3b8fb-2c297.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3b8fb-2c297.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?