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

I copied this from my personal log:

----- Original Message -----
From: "Doug Robinson" <drobinson@zicorp.com>
To: <instantDB@enhydra.org>
Sent: Tuesday, January 16, 2001 8:31 PM
Subject: RE: InstantDB: InstantDB, the Cassiopeia E-125 & the JVM


> Hi
> Big time difference!!
>
> By concatenating the UC & ID fields of
> the ImgCharA table I reduced the times taken
> to access the img24x24 field. By how much is a question
> I would rather leave for the future.
> This is good enough for the demo this program was
> originaly concieved as. Then it was only supposed to
> run on a 600MH PC.
>
> Thanks a bunch for the helping hand!!
>
> dkr
>
> -----Original Message-----
> From: Peter Hearty [mailto:peter.hearty@lutris.com]
> Sent: January 16, 2001 10:16 AM
> To: instantDB@enhydra.org
> Subject: Re: InstantDB: InstantDB, the Cassiopeia E-125 & the JVM
>
>
> Doug
>
> If it's possible to provide a unique, integer based primary key lookup
> then that *might* speed things up. I know I said the type of column
> shouldn't matter, and from the point of view of the lookup it doesn't,
> but from the point of view of selecting rows it could well do.
>
> Integer PKs preserve the order of their target column and so don't have
> to evaluate every row returned by the index. Text and/or multiple
> columns have to get rows back from the index and then evaluate the
> WHERE clause against them.
>
> This is only a theory though, so don't put too much effort into it - it
> might not work.
>
> Pete
>
> ----- Original Message -----
> From: Doug Robinson <drobinson@zicorp.com>
> Date: Tuesday, January 16, 2001 4:34 pm
> Subject: InstantDB: InstantDB, the Cassiopeia E-125 & the JVM
>
> > Hello
> >
> >    Here I am still working on the same program I asked about last
> > week.
> > I have a database with two tables:
> >
> >          stmt.executeUpdate ("CREATE TABLE tbl3000 (UC TEXT
> > PRIMARY KEY,
> > " +
> >                  "Str0 BINARY, type BYTE, Freq INT, basic8
> > SHORT)");
> >          stmt.executeUpdate ("CREATE INDEX basics ON tbl3000
> > (basic8)");
> >        stmt.executeUpdate ("CREATE TABLE ImgCharA (UC TEXT, " +
> >                 "ID BYTE, img24x24 BINARY)");
> >        stmt.executeUpdate ("CREATE INDEX unicodes ON ImgCharA (UC)");
> >
> >    tbl3000 has exactly 3000 records, ImgCharA has about 28000.
> >
> >    I have two basic selects:
> >
> >        SELECT * FROM tbl3000 WHERE basic8 = "BB" ORDER BY Freq DESC
> >
> >    This one "selects" somewhere between 1 an 135 records, takes 2-8
> > seconds & I can
> > live with that.
> >
> >        SELECT img24x24 FROM ImgCharA WHERE UC = "4E2D"  AND ID = 3
> >
> >    The UC-ID combination is unique so this select returns only
> > one 72
> > byte array. It takes
> > somewhere between 5 and 15 seconds. I am hoping to drasticaly
> > reduce this
> > some how!!
> >
> >    In addition, I have been forced to place a sleep (Thread,sleep
> > (100)) before each occurance of
> > the second select. If I do not do this I get this error message
> > from the
> > JVM:
> >    Java Panic
> >    Unable to suspend
> >    threads, 1024 (more?)
> >    times.
> >
> > I am desparate! Does anybody know what the error message means or
> > where I
> > could find out what it means?
> >
> > It may be that the Cassiopeia Pocket PC is just to slow for
> > InstantDB &
> > Java, that bad thought now withstanding;
> > how can I improve the response with the ImgCharA select.
> >
> >    Thanks for your time!
> >
> > dkr
> >
> > -------------------------------------------------------------------
> > ----------
> > 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.
> --------------------------------------------------------------------------
---
> 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.
>


-----Original Message-----
From: owner-instantDB@enhydra.org [mailto:owner-instantDB@enhydra.org]On
Behalf Of Martin Gagnon
Sent: Thursday, February 15, 2001 5:54 AM
To: 'instantDB@enhydra.org'
Subject: RE: InstantDB: Running InstantDB on WinCE


Pete,

I cannot access the old documents from the mailing list as I've been on it
for only few days and the "history" page on your website does not seem to
work.

Marty

-----Original Message-----
From: Peter Hearty [mailto:peter.hearty@lutris.com]
Sent: February 15, 2001 3:05 AM
To: instantDB@enhydra.org
Subject: Re: InstantDB: Running InstantDB on WinCE


I believe someone recently did a demon on a Cassiopeia. If you search the
mailing list you
should be able to get come more info.

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Martin Gagnon" <martin.gagnon@momentumhealthware.com>
To: <instantDB@enhydra.org>
Sent: Wednesday, February 14, 2001 9:57 PM
Subject: InstantDB: Running InstantDB on WinCE


> Hi,
>
> Does anyone know of a successful implementation of InstantDB on Personal
> Java for WinCE?
>
> Martin Gagnon
> Software Developer
> Momentum Healthware
> Phone - (204) 231-3836 extension 275
> Voice Mail - (204) 231-3836 extension 261
> Email - martin.gagnon@momentumhealthware.com
>
>
----------------------------------------------------------------------------
-
> 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.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.