At 02:16 PM 27-09-01 +0000, you wrote:

>My dev server is Pentium II 350 with 128 MB RAM on W2k Adv Server

How many CPUs?

>IBConfig file from IB6.0.1.6 (opened using notepad)
>
>V4_LOCK_MEM_SIZE 98304
>V4_LOCK_SEM_COUNT 32
>V4_LOCK_SIGNAL 16
>V4_EVENT_MEM_SIZE 32768
>DATABASE_CACHE_PAGES 75
>SERVER_PRIORITY_CLASS 1
>SERVER_CLIENT_MAPPING 4096
>SERVER_WORKING_SIZE_MIN 0
>SERVER_WORKING_SIZE_MAX 0
>V4_LOCK_GRANT_ORDER 1
>ANY_LOCK_MEM_SIZE 98304
>ANY_LOCK_SEM_COUNT 32
>ANY_LOCK_SIGNAL 16
>ANY_EVENT_MEM_SIZE 32768

Add one or more entries like this:

TMP_DIRECTORY 6000000 "f:\temp"

The number is in bytes. Allow a total size approx 2 X the size of your database. You can have one or more temp files - just make sure that each location will always have enough disk space available.

>PS How do you usually override these values?

Go to www.ibphoenix.com and search there. I'm sure there is a paper on the recommended settings in ibconfig.

Please watch your requoting.

Helen



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________