Helen,

Do I understand that there is nothing remarkable that would suggest
such poor performance.

I have made the changes you suggest.

Nothing improves with Interbase.

I am beginning to doubt your performance figures (amybe wishful
thinking).

You suggest that there is something wrong with the setup - I provided
the IBCONFIG settings - and the only change you suggest is adding a
temp file location?

Where are the performance enhancements settings?

Again both are generic out of the box - I quote the time it takes to
perform the query. You suggest InterBase should be better than
SQL_SERVER figures. I have made the changes with no difference.

Where is your proof?

How can you continue to suggest InterBase is better?

This is frustration talking ...

I would like VERY MUCH to believe you - make a few setting changes -
not re-write the app for a different db.

Specific suggestions - not reference to a white paper that may
exist .... please ... (fellow Aussie)

John Newcombe

--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
> 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?
>
One
>
> >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.
>

There are 3 entries about ibconfig - nothing that helps

> Please watch your requoting.
>
> Helen
>
>
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________