> what is the best way to solve the file size problem, in my program, I
> always need to use isc_database_info to get the isc_info_page_size
> and the isc_info_allocation after execute each command, calculate the
> file size and if the result is bigger than a number, alter the
> database to add the secondary file, but this seems not to have much
> efficiency. Does anyone have another method to solve this problem?
> Can trigger, event do that automatically instead of manual operation?
> Any suggestion are welcome.
>
>

what! are you adding 2Gb blobs or something?
You don't need to check this sort of thing regularly. What operating system
are you running? What is the size of the db? how much growth do you expect
over a 12 month period?
Alan