Re: [Hsqldb-user] Slow update

[Stefan S. <web...@go...>]

Hi Fred,

2005/11/21, fredt <fr...@us...>:
> This is how update operations are logged (a delete and an insert).
A very unefficient way!

> If this is a real performance issue for you, try dividing your table into
> two, both with the same primary key, one with the boolean field, the othe=
r
> with the varchar field.
That would be a way. For me, this is the first big handicap from hsqldb.

Thank you very much.

Stefan



> ----- Original Message -----
> From: "Stefan Schmidt" <web...@go...>
> To: <hsq...@li...>
> Sent: 21 November 2005 09:50
> Subject: Re: [Hsqldb-user] Slow update
>
>
> Hi,
>
> I'm using version 1.8.0.1 and Statements.
>
> Stefan
>
> 2005/11/17, Hillger, Thomas (regio iT) <Tho...@re...>=
:
> > Which version of HSQLDB do you use? Do you use Statement or
> > PreparedStatement within JDBC?
> >
> > Thomas
> >
> > -----Urspr=FCngliche Nachricht-----
> > Von: hsq...@li...
> > [mailto:hsq...@li...] Im Auftrag von Stefan
> > Schmidt
> > Gesendet: Mittwoch, 16. November 2005 22:02
> > An: hsq...@li...
> > Betreff: [Hsqldb-user] Slow update
> >
> > Hi all,
> >
> > is there no real "update" available?
> >
> > I have a cached table "MyTable" like this:
> >
> >   UID BIGINT      [with PRIMARY_KEY]
> >   INFO VARCHAR(100000)
> >   ISREAD BOOLEAN
> >
> > After a
> >   INSERT INTO MyTable VALUES(123,'Very large Text...','false')
> >   UPDATE MyTable SET ISREAD=3D'true' WHERE UID=3D123
> >
> > I found in the logfile 'MyTable.log' this 3 lines:
> >   INSERT INTO MyTable VALUES(123,'Very large Text...','false')
> >   DELETE FROM MyTable WHERE UID=3D123
> >   INSERT INTO MyTable VALUES(123,'Very large Text...','true')
> >
> > With long text this is very(!) slowly!
> >
> > Can anyone help me?
> >
> >
> > Bye
> >  Stefan
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam for All
> > Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_idv28&alloc_id=16845&op=3Dick
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsq...@li...
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_idv28&alloc_id=16845&opclick
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsq...@li...
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_idv28&alloc_id=16845&op=3Dick
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>