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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: InstantDB optimizations


Jason

Don't know if this is the same problem, but I alsu got an out of boubds 
exception until I upped singleRowCount to one from zero.

Pete

----- Original Message -----
From: Jason Amy <jason@cafesoft.com>
Date: Wednesday, January 31, 2001 6:19 pm
Subject: Re: InstantDB: InstantDB optimizations

> Peter, thanks for the minumum setting recommendation.
> 
> I tried running with the min settings you sent me, but was getting 
> null pointer
> exceptions:
> 
> java.sql.SQLException: java.lang.IndexOutOfBoundsException
> at 
> org.enhydra.instantdb.jdbc.idbConnection.<init>
(idbConnection.java:88) at org.enhydra.instantdb.jdbc.idbDriver.connect
(idbDriver.java:40)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> <snip>
> 
> 
> So I increased
> 
> systemCacheSize=100 (was 0)
> 
> Which got past the first null pointer exception, but now I get 
> this one
> (IndexOutOfBoundsException):
> 
> Enhydra InstantDB - Version 3.26 beta 2
> The Initial Developer of the Original Code is Lutris Technologies Inc.
> Portions created by Lutris are Copyright (C) 1997-2001 Lutris 
> Technologies, Inc.
> All Rights Reserved.
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 Closing 
> database App opens=1
> Database App is shutting down...
> Database App shutdown complete.
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 Opening 
> database dAWT-EventQueue-0 Opening database dAWT-EventQueue-0 
> Closing database App opens=3
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 Closing 
> database App opens=3
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 Closing 
> database App opens=3
> AWT-EventQueue-0 Closing database App opens=2
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 Closing 
> database App opens=2
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 Closing 
> database App opens=2
> AWT-EventQueue-0 Opening database dAWT-EventQueue-0 
> java.sql.SQLException: java.lang.IndexOutOfBoundsException
> 
> java.sql.SQLException: java.lang.IndexOutOfBoundsException
> at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:288)
> at
> org.enhydra.instantdb.jdbc.idbPreparedStatement.execute
(idbPreparedStatement.java:92)
> 
> at
> org.enhydra.instantdb.jdbc.idbPreparedStatement.executeQuery
(idbPreparedStatement.java:59)
> 
> I'm tinkering with the other settings, but can't seem to get past this
> IndexOutOfBoundsException.  I have tried this with 3.25 and 3.26b -
> same
> results.  If I revert back to the original settings, everything 
> works.  I'll keep
> tinkering away, and if anyone has any input it would be appreciated!
> 
> Thanks, Jason
> 
> 
> 
> Peter Hearty wrote:
> 
> > Jason
> >
> > The following properties can be adjusted to vary the sizes of 
> internal> buffers and caches. The values that follow sets 
> everything to pretty much
> > minimum values. I haven't tried these out. If they give any 
> problems then
> > try increasing them slightly. Their meanings are described in:
> >
> > 
> 
http://instantdb.enhydra.org/software/documentation/idb3_26b2/props.html
>
> > cacheAmount=0
> > cacheCondition=CACHE_ROWS
> > systemCacheSize=0
> > systemCacheCondition=CACHE_ROWS
> > resultsOnDisk=1
> > resultsSetCache=CACHE_ROWS
> > resultsSetCacheAmount=0
> > rowCacheSize=16
> > singleRowCount=0
> > systemRows=0
> > controlColCacheSize=16
> > traceLevel=0
> >
> > In addition, if you want IDB to do garbage collection (3.26 beta 
> 2 only)
> > then set:
> >
> > garbageCollectStatements=10
> > garbageCollectPercent=70
> >
> > Also, if the data is read only, then set:
> >
> > transLevel=0
> >
> > Regards
> >
> > Pete
> >
> > --
> >
> > Peter Hearty                         peter.hearty@lutris.com
> > Lutris Technologies (UK)        http://www.lutris.com
> > ----- Original Message -----
> > From: "Jason Amy" <jason@cafesoft.com>
> > To: <InstantDB@enhydra.org>
> > Sent: Friday, January 26, 2001 5:06 PM
> > Subject: InstantDB: InstantDB optimizations
> >
> > > Hello,
> > >
> > > I looked in the mail archives for information regarding my 
> question, but
> > > could find none, so here goes:
> > >
> > > We have an application that runs on a users desktop.  The 
> application> > has 'plugins' which are pieces of code that we can 
> write that seamlessly
> > > plugin to the main app.  One of these plugins uses InstantDB.  Our
> > > problem lies in when a particular plugin starts, it runs 
> queries on a
> > > single InstantDB database.  This database has 10 tables, and 
> all the
> > > tables combines are .97 megabyte.  None of the tables has more 
> than 7
> > > columns, and an average of about I'd say 50 rows.  Most data 
> is of type
> > > char(10) (My SQL syntax may be off, but they're mostly small 
> strings).> > We are noticing a 'jump' in memory usage when the 
> plugin is initialized
> > > (actually our client has mentioned this memory spike).  Using
> > > OptimizeIt! I have noticed the largest consumer of memory to 
> be the
> > > byte[] and char[].  The spike is between 4 and 5 megs (we are 
> trying to
> > > keep this down to less than 2 megs).  I have changed some of the
> > > optimization settins in the .prp file (namely the 
> resultsOnDisk to = 1),
> > > but do not seem to notice much difference.  If someone out 
> there has
> > > come across this problem, or can enlighten me, it would be greatly
> > > appreciated!
> > >
> > > -Thanks, Jason
> > >
> > > ---------------------------------------------------------------
> -----------
> > ---
> > > 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.
> > >
> >
> > -----------------------------------------------------------------
> ------------
> > 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.
> 
> -------------------------------------------------------------------
> ----------
> 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.