--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > 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

Because there is no guranteen how much growth of the client data, and
also the client do not know about that, so we have to handle this
problem, we have to decide the worst case