Hi Aage

At 03:02 am 11/02/2004, you wrote:

>Hardly any tuning is required, and there isn't much to tune.
>Choose a page size that suits your data (size of database) - 4KB or 8KB is
>fine for most situations.

Okay. I guess Marathon gave me a default of 1024, can I change it to 4 or
8K after creation of the database?

>Choose a buffer size (depending on architecture: CS or SS), number of
>active databases, and available RAM (and for CS: active users).
>With SS, start at 5000-10000 pages for cache size if this fits with RAM
>size etc. I don't know whether the old 'truth' that one should not exceed
>about 10.000 cache pages (which makes for about 80MB RAM with 8KB page
>size) for a database still holds.

I just got lost, sorry.

>Use gbak regularly, and occasionally do a restore to a new database to
>check that backups are OK.

Okay. Thanks.

>That's it.
>Make sure that transaction numbers advance properly (no stuck or
>everlasting transactions) - if you have a period of inactivity (no users
>connected) you might schedule a SWEEP to clean up transaction numbers and
>garbage.

Sorry, didn't get it.

>Check that you don't have indexes with very bad selectivity on large
>tables. ("bad' selecticity means 'low' selectivity which in IB/Fb is
>indicated by a high number - IIRC).

I don't really plan to use indexes. There are default as created for
PK. Are other Indexes necessary. I will be using FB through ODBC in VFP
so I will be pulling in limited data, generally.

Thanks for your help.



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.581 / Virus Database: 368 - Release Date: 09/02/2004


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