Subject | Get the database page size from Jaybird |
---|---|
Author | Bill Oliver |
Post date | 2006-11-09T16:13:52Z |
Any way to get the databas page size from Jaybird?
Really, my first thought was that the page size should be a column in
the RDB$DATABASE table, and then I could query it directly, but this
does not seem to be the case.
The reason I ask, is that a user wants to ensure that the DBA creates
the database with page size of 16K, to take advantage of larger index
size. He would like to query the value and throw an error if it is not
16k.
I told him to try and create his index within a TRY/CATCH block. If
the index creation fails, catch the error and check the SQL CODE, to
see if page size was too small. This approach was deemed to lack a
certain amount of elegance, though.
-bill
Really, my first thought was that the page size should be a column in
the RDB$DATABASE table, and then I could query it directly, but this
does not seem to be the case.
The reason I ask, is that a user wants to ensure that the DBA creates
the database with page size of 16K, to take advantage of larger index
size. He would like to query the value and throw an error if it is not
16k.
I told him to try and create his index within a TRY/CATCH block. If
the index creation fails, catch the error and check the SQL CODE, to
see if page size was too small. This approach was deemed to lack a
certain amount of elegance, though.
-bill