Have you tried setting up another server...

You may already have done this, but if not, it doesn't take long... Do a
backup and restore to the new database, if things still don't work
then... Who knows... Maybe just try it on a simplified version of the
database...

I have had sad performance every now and then, usually I have found very
obvious problems, like triggers on tables doing stupid things (as
programmed!) slowing things down...

In summary... I am sure (well, just guessing actually) that if you
offered Helen enough money, she would come and sort your problem out!!
:-)

I think sometimes it is hard to tell what is wrong just via email, but
many people do try... And we do appreciate it...

Just thought I would trough in a thanks to Helen and the others who have
helped me overtime... Hope that they can help you further too...

Regards
Colin

-----Original Message-----
From: john@... [mailto:john@...]
Sent: Friday, 28 September 2001 8:58 a.m.
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Why is Interbase so slow?


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
> _______________________________________________________



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################