Leyne, Sean wrote:

>NAS,
>
>

thank you for your replay

>
>
>>I use middle to acces database to insert or update and web for
>>
>>
>reporting.
>
>
>>Server IBM x366 Double processor, I use Redhat enterprise 3.
>>what should I do :
>>1. Split file database or just use one file ?
>>
>>
>
>Personally, I would only recommend split databases if ABSOLUTELY
>necessary.
>
>
>
>>2. Install Super server or Clasic server ?
>>
>>
>
>Depends on how many DB connections you will have.
>
>
>
>

My middle app use one connection to handle all client, i use UIB V2 to
handle database connection

>>3. How about limit size perdatabase
>> 7 T or 32 T ?
>>4. How about filesize ?
>>
>>
>
>The maximum database and filesize work out to be the same, well above
>1TB. I can't say I've ever heard of someone running a database larger
>than 900GB.
>
>
>
>
>>5. How Page size ?
>>
>>
>
>I would recommend at least 8KB
>
>
>
>
>>7. others
>>
>>
>
>Is your application made up of a large number of table or a small number
>of table with a large amount of data?
>
>

I use 36 tables
2 table reference with about 15,500,000 records
- Customer table with 10 fields
- Account table with 7 fields
1 table transactions with about 4 * 15,500,000 records
- Transaction table with 7 fields

>The reason I ask is because v2.0 has a new internal record ID size which
>allows for a single table to store more than 30-40GB of data. (The new
>limit is > 1 TB)
>
>

V2 still in alpha 3 stages ?

>
>
>

if i use table with unary relationship it's will decrease performance
in select (this table contain about 10000 records data reference) ?

>Sean
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>