Subject | Re: [firebird-support] Issues with .Net Data Provider |
---|---|
Author | Aage Johansen |
Post date | 2005-08-21T18:52:52Z |
Ken & Deb Allen wrote:
something different (not using the default). Anyway, I don't think 1KB
page size would create this type of problem when you record size is just 48B.
You can set the page size when you create a database or when restoring
(with gbak). (How you do tha with the .Net provider is something I know
less than nothing about...)
It seems strange that the databae got that big - unless there are lots of
indexes and/or garbage (delete records or stubs of updated ones). You
could backup+restore the database to clean out the garbage and see what the
"true" size is.
--
Aage J.
> In the original email I indicated that the 'raw' size of the records4KB is probably just fine. But do check this - maybe your tool chose
> was only 48 bytes, so these are not long records.
>
> I have not specified the page size, but saw a note that indicated the
> default page size for Firebird was 4KB; if this is not the case, how
> do I set the page size when creating the database from the .Net Data
> Provider using the embedded/stand-alone/single-use database?
>
something different (not using the default). Anyway, I don't think 1KB
page size would create this type of problem when you record size is just 48B.
You can set the page size when you create a database or when restoring
(with gbak). (How you do tha with the .Net provider is something I know
less than nothing about...)
It seems strange that the databae got that big - unless there are lots of
indexes and/or garbage (delete records or stubs of updated ones). You
could backup+restore the database to clean out the garbage and see what the
"true" size is.
--
Aage J.