Hi Aage

At 02:42 am 12/02/2004, you wrote:

>As Alan said, backup and restore with new page size.

Okay

>If you have a page size of 8KB and a cache of 8192 pages, you will need
>64MB RAM (plus some small fixed "overhead"). If you have to databases like
>this opened, you'll need twice the RAM.
>With IB/5.6 (and earlier/later versions?) there was little (if anything) to
>gain by increasing the cache much above 10000 pages, but YMMV.

I just read the FireBird.conf it has a note that the superserver has a
cache of 2048 per database so having a default as per Marathon 1024 per
page and 2048 pages per database is 2MB per database, right?

My current app is a simple app with low single user traffic then is this
okay (ie. 2MB)?

>With time you will ... - I don't know how to explain it in a simple way.
>If you usually have no clients connected at night, I think you should do a
>backup (gbak) followed by a sweep (gfix -sweep) - you can then run gbak
>with 'garbage collection' turned off.
>If there are clients connected 'always', just run gbak ('garbage
>collection' is turned on by default). And occasionally watch the
>statistics on the 'header page' - don't let the 'transaction gap' become
>too wide. You can use IBOconsole (or a command line utility) for this.
>These are lines to look for:
> Oldest transaction 105
> Oldest active 859
> Oldest snapshot 859
> Next transaction 860
>The numbers shouldn't be too far apart. (After a SWEEP, the 105 moved up
>to 860)

Okay thanks, I get the gist of it, but like you said time and maybe my
desperate post here will tell <g>.

>If your selection criteria don't include the PK you may need indexes unless
>the tables are small (or if speed doesn't matter much).

Okay I will keep that in mind, but for the current app the tables will be
small.

Thanks a lot for clarifying all my queries.



Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
venussoftop@...
venussoftop@...
venussoftop@...
venussoftop@...
vso_ad1@...
___________________________________________


Please note: We reserve complete rights for policy changes in the future
and the same will be applicable immediately as and when made. Attachments
may get corrupted before reaching you, in such a situation please let us
know and we will resend you the same at the earliest. We do not take any
responsibility for data loss of any type and kind. Data safety remains the
sole the responsibility of the users of our softwares.
___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or
confidential. If you are not the addressee nor are you responsible for the
delivery of the message to the addressee indicated in this email, then you
may not copy or deliver this email to anyone and you should notify the
sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject,
if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by my company.


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 10/02/2004


[Non-text portions of this message have been removed]