InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Norman

I agree. A section on the optimal settings for various performance 
objectives is a good idea. In the mean time, I think these are the best 
settings for using least memory.

cacheAmount=0
cacheCondition=CACHE_ROWS
systemCacheSize=0
systemCacheCondition=CACHE_ROWS
resultsOnDisk=1
resultsSetCache=CACHE_ROWS
resultsSetCacheAmount=0
rowCacheSize=16
singleRowCount=1
systemRows=0
controlColCacheSize=16
traceLevel=0

In addition, if you want IDB to do garbage collection (3.26 only)
then set:

garbageCollectStatements=10
garbageCollectPercent=70

Also, if the data is read only, then set:

transLevel=0

For speed - basically increase all the memory related properties and 
set:

fastUpdate=1
resultsOnDisk=1

There's not really a "best" set of values for speed. It's just a matter 
of increasing caches etc. until things don't go any faster.

Pete

----- Original Message -----
From: "Norman Kabir" <nkabir@eredyne.com>
Date: Sunday, February 18, 2001 2:40 pm
Subject: InstantDB: IntantDb Settings and Documentation

> Greetings.
> 
> InstantDb has proven to be very flexible. However, I've had some 
> troublefiguring out the proper settings for the .prp file.
> 
> Is there somewhere I can get the proper settings for:
> 1. The most efficient settings for InstantDb (i.e. least RAM)
> 2. The highest performance settings for InstantDb (i.e. fastest 
> queries)
> It would be tremendously helpful to have these settings as part of the
> documentation. They would help provide resource/performance 
> guidelines for
> mobile/embedded systems.
> 
> Thank you.
> 
> 
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to 
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the 
> body of the email.
> If you have other questions regarding this mailing list, send 
> email to
> the list admin at owner-instantdb@enhydra.org.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.